1 INTRODUCCIÓN Y DEFINICIÓN DE OBJETIVOS


En este proyecto vamos a estudiar el dataset llamado “combined_data_laliga.csv” donde se encuentran todos los partidos de la temporada 2014 hasta la temporada 2020, ambas incluidas, con una recopilación de los principales eventos que ocurren en un partido, goles, tiros a puerta, faltas, tarjetas…


  • ¿Qué hace que un equipo gane un partido?
  • ¿Qué variables influyen en las victorias?
  • ¿Es posible predecir el ganador de un partido?


Para dar respuesta a todas estas preguntas estos han sido los pasos que hemos ido dando en nuestro estudio:

  • Lectura y exploración inicial
  • Limpieza de datos
  • Trasformación de variables
  • División del dataset en train (2014 - 2019) y test (2020)
  • EDA
  • Regresión


1.1 LIBRERÍAS UTILIZADAS

library(dplyr)
library(tidyr)
library(knitr)
library(readr)
library(ggplot2)
library(cowplot)
library(GGally)
library(plotrix)


1.2 LECTURA DE DATOS

laliga <- read_csv("combined_data_laliga.csv")




2 ANÁLISIS EXPLORATORIO INICIAL


Exploración inicial de datos a través de estadísticos principales

str(laliga)
## spc_tbl_ [2,660 × 41] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
##  $ ...1                         : num [1:2660] 0 1 2 3 4 5 6 7 8 9 ...
##  $ Home Team                    : chr [1:2660] "MÁLAGA" "SEVILLA FC" "GRANADA" "ALMERÍA" ...
##  $ Away Team                    : chr [1:2660] "ATHLETIC" "VALENCIA" "DEPORTIVO" "ESPANYOL" ...
##  $ Score                        : chr [1:2660] "1-0" "1-1" "2-1" "1-1" ...
##  $ Half Time Score              : chr [1:2660] "1-0" "1-0" "0-1" "0-0" ...
##  $ Match Excitement             : num [1:2660] 4.4 4.7 4.6 5.6 3.7 5.1 7 4.7 4.7 2.1 ...
##  $ Home Team Rating             : num [1:2660] 6 6.5 7.2 6.9 6.5 8 7.3 5.6 6.9 6.9 ...
##  $ Away Team Rating             : num [1:2660] 5.7 6.8 5.9 5.5 5.9 5.3 5.5 7.3 5.5 5.9 ...
##  $ Home Team Possession %       : num [1:2660] 40 47 53 56 41 72 59 53 63 59 ...
##  $ Away Team Possession %       : num [1:2660] 60 53 47 44 59 28 41 47 37 41 ...
##  $ Home Team Off Target Shots   : num [1:2660] 5 4 6 7 5 5 4 4 3 5 ...
##  $ Home Team On Target Shots    : num [1:2660] 3 3 3 6 5 6 9 2 8 2 ...
##  $ Home Team Total Shots        : num [1:2660] 12 12 10 19 12 12 20 9 14 8 ...
##  $ Home Team Blocked Shots      : num [1:2660] 4 5 1 6 2 1 7 3 3 1 ...
##  $ Home Team Corners            : num [1:2660] 5 3 5 11 5 3 4 3 8 2 ...
##  $ Home Team Throw Ins          : num [1:2660] 13 20 25 26 28 23 21 16 25 23 ...
##  $ Home Team Pass Success %     : num [1:2660] 69 76 79 81 60 93 82 80 88 79 ...
##  $ Home Team Aerials Won        : num [1:2660] 11 13 20 19 29 2 27 19 23 21 ...
##  $ Home Team Clearances         : num [1:2660] 16 16 21 25 17 2 15 12 13 20 ...
##  $ Home Team Fouls              : num [1:2660] 13 23 13 8 13 11 19 11 9 13 ...
##  $ Home Team Yellow Cards       : num [1:2660] 3 4 1 3 4 0 4 1 1 2 ...
##  $ Home Team Second Yellow Cards: num [1:2660] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Home Team Red Cards          : num [1:2660] 2 0 0 0 0 1 0 0 0 0 ...
##  $ Away Team Off Target Shots   : num [1:2660] 5 5 1 6 7 3 8 5 6 3 ...
##  $ Away Team On Target Shots    : num [1:2660] 5 1 1 2 4 0 3 6 2 2 ...
##  $ Away Team Total Shots        : num [1:2660] 12 11 8 12 19 3 12 12 8 9 ...
##  $ Away Team Blocked Shots      : num [1:2660] 2 5 6 4 8 0 1 1 0 4 ...
##  $ Away Team Corners            : num [1:2660] 4 3 3 7 6 1 4 4 5 4 ...
##  $ Away Team Throw Ins          : num [1:2660] 22 27 30 19 36 19 19 14 18 34 ...
##  $ Away Team Pass Success %     : num [1:2660] 84 79 76 70 75 81 74 78 79 68 ...
##  $ Away Team Aerials Won        : num [1:2660] 17 14 10 11 25 4 22 21 15 26 ...
##  $ Away Team Clearances         : num [1:2660] 14 16 14 20 20 17 7 18 27 15 ...
##  $ Away Team Fouls              : num [1:2660] 9 8 26 9 14 13 15 14 13 17 ...
##  $ Away Team Yellow Cards       : num [1:2660] 3 2 3 3 1 1 1 3 2 2 ...
##  $ Away Team Second Yellow Cards: num [1:2660] 0 0 0 1 0 0 0 0 0 0 ...
##  $ Away Team Red Cards          : num [1:2660] 0 1 0 0 0 0 0 0 0 0 ...
##  $ Home Team Goals Scored       : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
##  $ Away Team Goals Scored       : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
##  $ Home Team Goals Conceeded    : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
##  $ Away Team Goals Conceeded    : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
##  $ year                         : num [1:2660] 2014 2014 2014 2014 2014 ...
##  - attr(*, "spec")=
##   .. cols(
##   ..   ...1 = col_double(),
##   ..   `Home Team` = col_character(),
##   ..   `Away Team` = col_character(),
##   ..   Score = col_character(),
##   ..   `Half Time Score` = col_character(),
##   ..   `Match Excitement` = col_double(),
##   ..   `Home Team Rating` = col_double(),
##   ..   `Away Team Rating` = col_double(),
##   ..   `Home Team Possession %` = col_double(),
##   ..   `Away Team Possession %` = col_double(),
##   ..   `Home Team Off Target Shots` = col_double(),
##   ..   `Home Team On Target Shots` = col_double(),
##   ..   `Home Team Total Shots` = col_double(),
##   ..   `Home Team Blocked Shots` = col_double(),
##   ..   `Home Team Corners` = col_double(),
##   ..   `Home Team Throw Ins` = col_double(),
##   ..   `Home Team Pass Success %` = col_double(),
##   ..   `Home Team Aerials Won` = col_double(),
##   ..   `Home Team Clearances` = col_double(),
##   ..   `Home Team Fouls` = col_double(),
##   ..   `Home Team Yellow Cards` = col_double(),
##   ..   `Home Team Second Yellow Cards` = col_double(),
##   ..   `Home Team Red Cards` = col_double(),
##   ..   `Away Team Off Target Shots` = col_double(),
##   ..   `Away Team On Target Shots` = col_double(),
##   ..   `Away Team Total Shots` = col_double(),
##   ..   `Away Team Blocked Shots` = col_double(),
##   ..   `Away Team Corners` = col_double(),
##   ..   `Away Team Throw Ins` = col_double(),
##   ..   `Away Team Pass Success %` = col_double(),
##   ..   `Away Team Aerials Won` = col_double(),
##   ..   `Away Team Clearances` = col_double(),
##   ..   `Away Team Fouls` = col_double(),
##   ..   `Away Team Yellow Cards` = col_double(),
##   ..   `Away Team Second Yellow Cards` = col_double(),
##   ..   `Away Team Red Cards` = col_double(),
##   ..   `Home Team Goals Scored` = col_double(),
##   ..   `Away Team Goals Scored` = col_double(),
##   ..   `Home Team Goals Conceeded` = col_double(),
##   ..   `Away Team Goals Conceeded` = col_double(),
##   ..   year = col_double()
##   .. )
##  - attr(*, "problems")=<externalptr>


summary(laliga) 
##       ...1         Home Team          Away Team            Score          
##  Min.   :   0.0   Length:2660        Length:2660        Length:2660       
##  1st Qu.: 664.8   Class :character   Class :character   Class :character  
##  Median :1329.5   Mode  :character   Mode  :character   Mode  :character  
##  Mean   :1329.5                                                           
##  3rd Qu.:1994.2                                                           
##  Max.   :2659.0                                                           
##  Half Time Score    Match Excitement Home Team Rating Away Team Rating
##  Length:2660        Min.   : 1.400   Min.   : 2.800   Min.   : 3.000  
##  Class :character   1st Qu.: 3.900   1st Qu.: 5.700   1st Qu.: 5.400  
##  Mode  :character   Median : 5.100   Median : 6.400   Median : 6.000  
##                     Mean   : 5.249   Mean   : 6.369   Mean   : 6.045  
##                     3rd Qu.: 6.300   3rd Qu.: 6.900   3rd Qu.: 6.600  
##                     Max.   :10.000   Max.   :10.000   Max.   :10.000  
##  Home Team Possession % Away Team Possession % Home Team Off Target Shots
##  Min.   :18.00          Min.   :17.00          Min.   : 0.000            
##  1st Qu.:44.00          1st Qu.:41.00          1st Qu.: 4.000            
##  Median :52.00          Median :48.00          Median : 5.000            
##  Mean   :51.54          Mean   :48.46          Mean   : 5.533            
##  3rd Qu.:59.00          3rd Qu.:56.00          3rd Qu.: 7.000            
##  Max.   :83.00          Max.   :82.00          Max.   :18.000            
##  Home Team On Target Shots Home Team Total Shots Home Team Blocked Shots
##  Min.   : 0.000            Min.   : 2.00         Min.   : 0.000         
##  1st Qu.: 3.000            1st Qu.:10.00         1st Qu.: 1.000         
##  Median : 4.000            Median :13.00         Median : 3.000         
##  Mean   : 4.648            Mean   :13.08         Mean   : 2.913         
##  3rd Qu.: 6.000            3rd Qu.:16.00         3rd Qu.: 4.000         
##  Max.   :17.000            Max.   :33.00         Max.   :12.000         
##  Home Team Corners Home Team Throw Ins Home Team Pass Success %
##  Min.   : 0.000    Min.   : 5.0        Min.   :46.00           
##  1st Qu.: 3.000    1st Qu.:18.0        1st Qu.:73.00           
##  Median : 5.000    Median :22.0        Median :78.00           
##  Mean   : 5.395    Mean   :22.5        Mean   :77.71           
##  3rd Qu.: 7.000    3rd Qu.:27.0        3rd Qu.:84.00           
##  Max.   :20.000    Max.   :49.0        Max.   :93.00           
##  Home Team Aerials Won Home Team Clearances Home Team Fouls
##  Min.   : 2.0          Min.   : 1.00        Min.   : 1.00  
##  1st Qu.:12.0          1st Qu.:12.00        1st Qu.:11.00  
##  Median :16.0          Median :17.00        Median :14.00  
##  Mean   :17.1          Mean   :17.71        Mean   :13.75  
##  3rd Qu.:22.0          3rd Qu.:22.00        3rd Qu.:16.00  
##  Max.   :52.0          Max.   :61.00        Max.   :33.00  
##  Home Team Yellow Cards Home Team Second Yellow Cards Home Team Red Cards
##  Min.   :0.000          Min.   :0.00000               Min.   :0.00000    
##  1st Qu.:1.000          1st Qu.:0.00000               1st Qu.:0.00000    
##  Median :2.000          Median :0.00000               Median :0.00000    
##  Mean   :2.417          Mean   :0.05602               Mean   :0.04699    
##  3rd Qu.:3.000          3rd Qu.:0.00000               3rd Qu.:0.00000    
##  Max.   :8.000          Max.   :2.00000               Max.   :2.00000    
##  Away Team Off Target Shots Away Team On Target Shots Away Team Total Shots
##  Min.   : 0.00              Min.   : 0.000            Min.   : 0.00        
##  1st Qu.: 3.00              1st Qu.: 2.000            1st Qu.: 7.00        
##  Median : 4.00              Median : 3.000            Median :10.00        
##  Mean   : 4.32              Mean   : 3.669            Mean   :10.36        
##  3rd Qu.: 6.00              3rd Qu.: 5.000            3rd Qu.:13.00        
##  Max.   :14.00              Max.   :13.000            Max.   :28.00        
##  Away Team Blocked Shots Away Team Corners Away Team Throw Ins
##  Min.   : 0.000          Min.   : 0.000    Min.   : 3.00      
##  1st Qu.: 1.000          1st Qu.: 2.000    1st Qu.:17.00      
##  Median : 2.000          Median : 4.000    Median :21.00      
##  Mean   : 2.391          Mean   : 4.215    Mean   :21.48      
##  3rd Qu.: 3.000          3rd Qu.: 6.000    3rd Qu.:26.00      
##  Max.   :13.000          Max.   :32.000    Max.   :45.00      
##  Away Team Pass Success % Away Team Aerials Won Away Team Clearances
##  Min.   :41.0             Min.   : 0.00         Min.   : 1.00       
##  1st Qu.:71.0             1st Qu.:11.00         1st Qu.:14.00       
##  Median :77.0             Median :16.00         Median :20.00       
##  Mean   :75.9             Mean   :16.75         Mean   :21.43       
##  3rd Qu.:82.0             3rd Qu.:21.00         3rd Qu.:27.00       
##  Max.   :93.0             Max.   :53.00         Max.   :63.00       
##  Away Team Fouls Away Team Yellow Cards Away Team Second Yellow Cards
##  Min.   : 0.00   Min.   :0.000          Min.   :0.00000              
##  1st Qu.:11.00   1st Qu.:2.000          1st Qu.:0.00000              
##  Median :13.00   Median :3.000          Median :0.00000              
##  Mean   :13.77   Mean   :2.641          Mean   :0.07744              
##  3rd Qu.:16.00   3rd Qu.:4.000          3rd Qu.:0.00000              
##  Max.   :30.00   Max.   :8.000          Max.   :2.00000              
##  Away Team Red Cards Home Team Goals Scored Away Team Goals Scored
##  Min.   :0.00000     Min.   : 0.000         Min.   :0.000         
##  1st Qu.:0.00000     1st Qu.: 1.000         1st Qu.:0.000         
##  Median :0.00000     Median : 1.000         Median :1.000         
##  Mean   :0.04887     Mean   : 1.518         Mean   :1.141         
##  3rd Qu.:0.00000     3rd Qu.: 2.000         3rd Qu.:2.000         
##  Max.   :2.00000     Max.   :10.000         Max.   :8.000         
##  Home Team Goals Conceeded Away Team Goals Conceeded      year     
##  Min.   :0.000             Min.   : 0.000            Min.   :2014  
##  1st Qu.:0.000             1st Qu.: 1.000            1st Qu.:2015  
##  Median :1.000             Median : 1.000            Median :2017  
##  Mean   :1.141             Mean   : 1.518            Mean   :2017  
##  3rd Qu.:2.000             3rd Qu.: 2.000            3rd Qu.:2019  
##  Max.   :8.000             Max.   :10.000            Max.   :2020


El dataframe contiene todos los partidos de la liga española de 7 temporadas (de 2014 a 2020).

  • 2660 observaciones (partidos)
  • 40 variables
  • 4 variables cualitativas (dos de tipo texto)
  • 36 variables cuantitativas discretas
  • No hay valores faltantes

Home Team: Equipo local
Away Team: Equipo visitante
Score: Resultado (ejemplo 2-1)
Half Time Score: Resultado al descanso (ejemplo 1-1)
Match Excitement: Emoción del partido (subjetiva)
Home Team Rating: Nota del local (subjetiva)
Away Team Rating: Nota del visitante (subjetiva)
Home Team Possession: Posesión local
Away Team Possession: Posesión visitante
Home Team off Target Shots: Tiros fuera local
Home Team on Target Shots: Tiros a puerta local
Home Team Total Shots: Total tiros local
Home Team Blocked Shots: Tiros bloqueados local
Home Team Corners: Corners local
Home Team Throw Ins: Centros local
Home Team Pass Success: Pases exitosos local
Home Team Aerials Won: Balones aereos ganados local
Home Team Clearances: Despejes local
Home Team Fouls: Faltas local
Home Team Yellow Cards: Amarillas local
Home Team Second Yellow Cards: Segundas amarillas local
Home Team Red Cards: Rojas local
Away Team off Target Shots: Tiros fuera visitante
Away Team on Target Shots: Tiros a puerta visitante
Away Team Total Shots: Total tiros visitante
Away Team Blocked Shots: Tiros bloqueados visitante
Away Team Corners: Corners visitante
Away Team Throw Ins: Centros visitante
Away Team Pass Success: Pases exitosos visitante
Away Team Aerials Won: Balones aereos ganados visitante
Away Team Clearances: Despejes visitante
Away Team Fouls: Faltas visitante
Away Team Yellow Cards: Amarillas visitante
Away Team Second Yellow Cards: Segundas amarillas visitante
Away Team Red Cards: Rojas visitante
Home Team Goals Scored: Goles local
Away Team Goals Scored: Goles visitante
Home Team Goals Conceeded: Goles visitante
Away Team Goals Conceeded: Goles local
Year: Año


3 LIMPIEZA Y CREACIÓN


3.1 LIMPIEZA DE DATOS


Limpieza de datos en columnas quitando los espacios y cambiandolos por guiones ya que los espacios dan bastantes problemas a la hora de llamar a las variables.

names(laliga) <- gsub(" ","_", names(laliga))

Limpieza de variables que no nos interesa estudiar

laliga$Score <-  NULL
laliga$`Half_Time_Score` <- NULL
laliga$`Match_Excitement` <- NULL
laliga$`Home_Team_Rating` <- NULL
laliga$`Away_Team_Rating` <- NULL
laliga$`Home_Team_Goals_Conceeded` <- NULL
laliga$`Away_Team_Goals_Conceeded` <- NULL


3.2 CREACIÓN DE NUEVAS VARIABLES


Creación de campos que interesa estudiar más adelante

laliga <- mutate(laliga, score = ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored > 0, "1",
                                          ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored < 0, "2", "x")))

laliga <- mutate(laliga, goals = Home_Team_Goals_Scored + Away_Team_Goals_Scored)

laliga <- mutate(laliga, home_points = case_when(score == 1 ~ 3,
                                                 score == "x" ~ 1,
                                                 score == 2 ~ 0))
laliga <- mutate(laliga, away_points = case_when(score == 1 ~ 0,
                                                 score == "x" ~ 1,
                                                 score == 2 ~ 3))

laliga <- mutate(laliga, jornada = ceiling(row_number() / 10)) %>%
        mutate(jornada = (jornada - 1) %% 38 + 1)


Creación de campos que se quieren estudiar conforme avance el proyecto.

laliga <- mutate(laliga, total_off_target_shots = Home_Team_Off_Target_Shots + Away_Team_Off_Target_Shots)
laliga <- mutate(laliga, total_on_target_shots = Home_Team_On_Target_Shots + Away_Team_On_Target_Shots)
laliga <- mutate(laliga, total_shots = Home_Team_Total_Shots + Away_Team_Total_Shots)
laliga <- mutate(laliga, total_blocked_shots = Home_Team_Blocked_Shots + Away_Team_Blocked_Shots)
laliga <- mutate(laliga, total_corners = Home_Team_Corners + Away_Team_Corners)
laliga <- mutate(laliga, total_throw_ins = Home_Team_Throw_Ins + Away_Team_Throw_Ins)
laliga <- mutate(laliga, total_pass_success = `Home_Team_Pass_Success_%` + `Away_Team_Pass_Success_%`)
laliga <- mutate(laliga, total_aerials_won = Home_Team_Aerials_Won + Away_Team_Aerials_Won)
laliga <- mutate(laliga, total_clearances = Home_Team_Clearances + Away_Team_Clearances)
laliga <- mutate(laliga, total_fouls = Home_Team_Fouls + Away_Team_Fouls)
laliga <- mutate(laliga, total_yellow_cards = Home_Team_Yellow_Cards + Away_Team_Yellow_Cards)
laliga <- mutate(laliga, total_second_yellow_cards = Home_Team_Second_Yellow_Cards + Away_Team_Second_Yellow_Cards)
laliga <- mutate(laliga, total_red_cards = Home_Team_Red_Cards + Away_Team_Red_Cards)


3.3 CONVERSIÓN DE VARIABLES


Convertimos determinadas variables a categorías.

laliga$Home_Team <- as.factor(laliga$Home_Team)
laliga$Away_Team <- as.factor(laliga$Away_Team)
laliga$score <- factor(laliga$score, levels = c("1", "x", "2"))


3.4 DIVISIÓN TRAIN - TEST


Dividimos el dataset original en train y test. Decidimos que train contenga 6 de las 7 temporadas para utilizar los partidos de la 7ª (temp. 2020) en la fase de test.

test <- filter(laliga, year==2020)
train <- filter(laliga, year<2020)

#write.csv(test,"test/test_laliga.csv")
#write.csv(train,"train/train_laliga.csv")


3.5 CREACIÓN DE DATASETS ÚTILES


Creación de dataset útiles para diversos análisis y comparativas. Dataframes separados por tipo de resultado “score”.

Victorias_casa <- train %>% filter(score==1)
Derrotas_casa <- train %>% filter(score==2)
Empates <- train %>% filter(score=="x")


3.6 RESUMEN FINAL DE VARIABLES


str(train)
## tibble [2,280 × 52] (S3: tbl_df/tbl/data.frame)
##  $ ...1                         : num [1:2280] 0 1 2 3 4 5 6 7 8 9 ...
##  $ Home_Team                    : Factor w/ 31 levels "ALAVÉS","ALMERÍA",..: 21 28 16 2 10 5 7 20 26 24 ...
##  $ Away_Team                    : Factor w/ 31 levels "ALAVÉS","ALMERÍA",..: 3 29 9 12 27 11 13 31 8 4 ...
##  $ Home_Team_Possession_%       : num [1:2280] 40 47 53 56 41 72 59 53 63 59 ...
##  $ Away_Team_Possession_%       : num [1:2280] 60 53 47 44 59 28 41 47 37 41 ...
##  $ Home_Team_Off_Target_Shots   : num [1:2280] 5 4 6 7 5 5 4 4 3 5 ...
##  $ Home_Team_On_Target_Shots    : num [1:2280] 3 3 3 6 5 6 9 2 8 2 ...
##  $ Home_Team_Total_Shots        : num [1:2280] 12 12 10 19 12 12 20 9 14 8 ...
##  $ Home_Team_Blocked_Shots      : num [1:2280] 4 5 1 6 2 1 7 3 3 1 ...
##  $ Home_Team_Corners            : num [1:2280] 5 3 5 11 5 3 4 3 8 2 ...
##  $ Home_Team_Throw_Ins          : num [1:2280] 13 20 25 26 28 23 21 16 25 23 ...
##  $ Home_Team_Pass_Success_%     : num [1:2280] 69 76 79 81 60 93 82 80 88 79 ...
##  $ Home_Team_Aerials_Won        : num [1:2280] 11 13 20 19 29 2 27 19 23 21 ...
##  $ Home_Team_Clearances         : num [1:2280] 16 16 21 25 17 2 15 12 13 20 ...
##  $ Home_Team_Fouls              : num [1:2280] 13 23 13 8 13 11 19 11 9 13 ...
##  $ Home_Team_Yellow_Cards       : num [1:2280] 3 4 1 3 4 0 4 1 1 2 ...
##  $ Home_Team_Second_Yellow_Cards: num [1:2280] 0 0 0 0 0 0 0 0 0 0 ...
##  $ Home_Team_Red_Cards          : num [1:2280] 2 0 0 0 0 1 0 0 0 0 ...
##  $ Away_Team_Off_Target_Shots   : num [1:2280] 5 5 1 6 7 3 8 5 6 3 ...
##  $ Away_Team_On_Target_Shots    : num [1:2280] 5 1 1 2 4 0 3 6 2 2 ...
##  $ Away_Team_Total_Shots        : num [1:2280] 12 11 8 12 19 3 12 12 8 9 ...
##  $ Away_Team_Blocked_Shots      : num [1:2280] 2 5 6 4 8 0 1 1 0 4 ...
##  $ Away_Team_Corners            : num [1:2280] 4 3 3 7 6 1 4 4 5 4 ...
##  $ Away_Team_Throw_Ins          : num [1:2280] 22 27 30 19 36 19 19 14 18 34 ...
##  $ Away_Team_Pass_Success_%     : num [1:2280] 84 79 76 70 75 81 74 78 79 68 ...
##  $ Away_Team_Aerials_Won        : num [1:2280] 17 14 10 11 25 4 22 21 15 26 ...
##  $ Away_Team_Clearances         : num [1:2280] 14 16 14 20 20 17 7 18 27 15 ...
##  $ Away_Team_Fouls              : num [1:2280] 9 8 26 9 14 13 15 14 13 17 ...
##  $ Away_Team_Yellow_Cards       : num [1:2280] 3 2 3 3 1 1 1 3 2 2 ...
##  $ Away_Team_Second_Yellow_Cards: num [1:2280] 0 0 0 1 0 0 0 0 0 0 ...
##  $ Away_Team_Red_Cards          : num [1:2280] 0 1 0 0 0 0 0 0 0 0 ...
##  $ Home_Team_Goals_Scored       : num [1:2280] 1 1 2 1 1 3 3 0 2 0 ...
##  $ Away_Team_Goals_Scored       : num [1:2280] 0 1 1 1 0 0 1 2 0 0 ...
##  $ year                         : num [1:2280] 2014 2014 2014 2014 2014 ...
##  $ score                        : Factor w/ 3 levels "1","x","2": 1 2 1 2 1 1 1 3 1 2 ...
##  $ goals                        : num [1:2280] 1 2 3 2 1 3 4 2 2 0 ...
##  $ home_points                  : num [1:2280] 3 1 3 1 3 3 3 0 3 1 ...
##  $ away_points                  : num [1:2280] 0 1 0 1 0 0 0 3 0 1 ...
##  $ jornada                      : num [1:2280] 1 1 1 1 1 1 1 1 1 1 ...
##  $ total_off_target_shots       : num [1:2280] 10 9 7 13 12 8 12 9 9 8 ...
##  $ total_on_target_shots        : num [1:2280] 8 4 4 8 9 6 12 8 10 4 ...
##  $ total_shots                  : num [1:2280] 24 23 18 31 31 15 32 21 22 17 ...
##  $ total_blocked_shots          : num [1:2280] 6 10 7 10 10 1 8 4 3 5 ...
##  $ total_corners                : num [1:2280] 9 6 8 18 11 4 8 7 13 6 ...
##  $ total_throw_ins              : num [1:2280] 35 47 55 45 64 42 40 30 43 57 ...
##  $ total_pass_success           : num [1:2280] 153 155 155 151 135 174 156 158 167 147 ...
##  $ total_aerials_won            : num [1:2280] 28 27 30 30 54 6 49 40 38 47 ...
##  $ total_clearances             : num [1:2280] 30 32 35 45 37 19 22 30 40 35 ...
##  $ total_fouls                  : num [1:2280] 22 31 39 17 27 24 34 25 22 30 ...
##  $ total_yellow_cards           : num [1:2280] 6 6 4 6 5 1 5 4 3 4 ...
##  $ total_second_yellow_cards    : num [1:2280] 0 0 0 1 0 0 0 0 0 0 ...
##  $ total_red_cards              : num [1:2280] 2 1 0 0 0 1 0 0 0 0 ...


Las nuevas variables creadas son las siguientes:

  • score: resultado 1 X 2
  • goals: total goles del partido
  • home_points: puntos del equipo local
  • away_points: de tipo categórico
  • jornada: nº de jornada liguera
  • total_off_target_shots: total disparos NO a puerta
  • total_on_target_shots: total disparos a puerta
  • total_shots: total disparos
  • total_blocked_shots: total disparos bloqueados
  • total_corners: corners totales
  • total_throw_ins: total centros al área
  • total_pass_success: pases totales con éxito
  • total_aerials_won: balones aéreos ganados totales
  • total_clearances: despejes totales
  • total_fouls: faltas totales
  • total_yellow_cards: tarjetas amarillas totales
  • total_second_yellow_cards: segundas tarjetas amarillas totales
  • total_red_cards: tarjetas rojas totales


summary(train)
##       ...1                  Home_Team              Away_Team   
##  Min.   :   0.0   ATHLETIC       : 114   ATHLETIC       : 114  
##  1st Qu.: 569.8   ATLETICO MADRID: 114   ATLETICO MADRID: 114  
##  Median :1139.5   BARCELONA      : 114   BARCELONA      : 114  
##  Mean   :1139.5   CELTA          : 114   CELTA          : 114  
##  3rd Qu.:1709.2   EIBAR          : 114   EIBAR          : 114  
##  Max.   :2279.0   ESPANYOL       : 114   ESPANYOL       : 114  
##                   (Other)        :1596   (Other)        :1596  
##  Home_Team_Possession_% Away_Team_Possession_% Home_Team_Off_Target_Shots
##  Min.   :19.00          Min.   :17.00          Min.   : 0.000            
##  1st Qu.:44.00          1st Qu.:41.00          1st Qu.: 4.000            
##  Median :52.00          Median :48.00          Median : 5.000            
##  Mean   :51.68          Mean   :48.32          Mean   : 5.635            
##  3rd Qu.:59.00          3rd Qu.:56.00          3rd Qu.: 7.000            
##  Max.   :83.00          Max.   :81.00          Max.   :18.000            
##                                                                          
##  Home_Team_On_Target_Shots Home_Team_Total_Shots Home_Team_Blocked_Shots
##  Min.   : 0.000            Min.   : 2.00         Min.   : 0.000         
##  1st Qu.: 3.000            1st Qu.:10.00         1st Qu.: 2.000         
##  Median : 4.000            Median :13.00         Median : 3.000         
##  Mean   : 4.757            Mean   :13.36         Mean   : 2.978         
##  3rd Qu.: 6.000            3rd Qu.:16.00         3rd Qu.: 4.000         
##  Max.   :17.000            Max.   :33.00         Max.   :12.000         
##                                                                         
##  Home_Team_Corners Home_Team_Throw_Ins Home_Team_Pass_Success_%
##  Min.   : 0.000    Min.   : 5.00       Min.   :46.00           
##  1st Qu.: 3.000    1st Qu.:18.00       1st Qu.:73.00           
##  Median : 5.000    Median :22.00       Median :78.00           
##  Mean   : 5.556    Mean   :22.76       Mean   :77.64           
##  3rd Qu.: 7.000    3rd Qu.:27.00       3rd Qu.:83.00           
##  Max.   :20.000    Max.   :49.00       Max.   :93.00           
##                                                                
##  Home_Team_Aerials_Won Home_Team_Clearances Home_Team_Fouls
##  Min.   : 2.00         Min.   : 1.00        Min.   : 1.00  
##  1st Qu.:12.00         1st Qu.:12.00        1st Qu.:11.00  
##  Median :16.00         Median :17.00        Median :14.00  
##  Mean   :17.12         Mean   :18.01        Mean   :13.82  
##  3rd Qu.:22.00         3rd Qu.:23.00        3rd Qu.:17.00  
##  Max.   :50.00         Max.   :61.00        Max.   :33.00  
##                                                            
##  Home_Team_Yellow_Cards Home_Team_Second_Yellow_Cards Home_Team_Red_Cards
##  Min.   :0.000          Min.   :0.00000               Min.   :0.00000    
##  1st Qu.:1.000          1st Qu.:0.00000               1st Qu.:0.00000    
##  Median :2.000          Median :0.00000               Median :0.00000    
##  Mean   :2.465          Mean   :0.05833               Mean   :0.04561    
##  3rd Qu.:3.000          3rd Qu.:0.00000               3rd Qu.:0.00000    
##  Max.   :8.000          Max.   :2.00000               Max.   :2.00000    
##                                                                          
##  Away_Team_Off_Target_Shots Away_Team_On_Target_Shots Away_Team_Total_Shots
##  Min.   : 0.000             Min.   : 0.000            Min.   : 0.00        
##  1st Qu.: 3.000             1st Qu.: 2.000            1st Qu.: 7.00        
##  Median : 4.000             Median : 3.000            Median :10.00        
##  Mean   : 4.336             Mean   : 3.708            Mean   :10.43        
##  3rd Qu.: 6.000             3rd Qu.: 5.000            3rd Qu.:13.00        
##  Max.   :14.000             Max.   :13.000            Max.   :28.00        
##                                                                            
##  Away_Team_Blocked_Shots Away_Team_Corners Away_Team_Throw_Ins
##  Min.   : 0.000          Min.   : 0.000    Min.   : 3.00      
##  1st Qu.: 1.000          1st Qu.: 2.000    1st Qu.:17.00      
##  Median : 2.000          Median : 4.000    Median :21.00      
##  Mean   : 2.408          Mean   : 4.202    Mean   :21.59      
##  3rd Qu.: 3.000          3rd Qu.: 6.000    3rd Qu.:26.00      
##  Max.   :11.000          Max.   :32.000    Max.   :45.00      
##                                                               
##  Away_Team_Pass_Success_% Away_Team_Aerials_Won Away_Team_Clearances
##  Min.   :41.0             Min.   : 0.00         Min.   : 2.00       
##  1st Qu.:71.0             1st Qu.:11.00         1st Qu.:15.00       
##  Median :77.0             Median :16.00         Median :21.00       
##  Mean   :75.7             Mean   :16.68         Mean   :22.21       
##  3rd Qu.:82.0             3rd Qu.:21.00         3rd Qu.:28.00       
##  Max.   :93.0             Max.   :53.00         Max.   :63.00       
##                                                                     
##  Away_Team_Fouls Away_Team_Yellow_Cards Away_Team_Second_Yellow_Cards
##  Min.   : 0.00   Min.   :0.000          Min.   :0.00000              
##  1st Qu.:11.00   1st Qu.:2.000          1st Qu.:0.00000              
##  Median :14.00   Median :3.000          Median :0.00000              
##  Mean   :13.86   Mean   :2.707          Mean   :0.08202              
##  3rd Qu.:17.00   3rd Qu.:4.000          3rd Qu.:0.00000              
##  Max.   :30.00   Max.   :8.000          Max.   :2.00000              
##                                                                      
##  Away_Team_Red_Cards Home_Team_Goals_Scored Away_Team_Goals_Scored
##  Min.   :0.00000     Min.   : 0.000         Min.   :0.000         
##  1st Qu.:0.00000     1st Qu.: 1.000         1st Qu.:0.000         
##  Median :0.00000     Median : 1.000         Median :1.000         
##  Mean   :0.04868     Mean   : 1.543         Mean   :1.141         
##  3rd Qu.:0.00000     3rd Qu.: 2.000         3rd Qu.:2.000         
##  Max.   :2.00000     Max.   :10.000         Max.   :8.000         
##                                                                   
##       year      score        goals         home_points     away_points   
##  Min.   :2014   1:1056   Min.   : 0.000   Min.   :0.000   Min.   :0.000  
##  1st Qu.:2015   x: 573   1st Qu.: 1.000   1st Qu.:0.000   1st Qu.:0.000  
##  Median :2016   2: 651   Median : 2.000   Median :1.000   Median :1.000  
##  Mean   :2016            Mean   : 2.684   Mean   :1.641   Mean   :1.108  
##  3rd Qu.:2018            3rd Qu.: 4.000   3rd Qu.:3.000   3rd Qu.:3.000  
##  Max.   :2019            Max.   :12.000   Max.   :3.000   Max.   :3.000  
##                                                                          
##     jornada     total_off_target_shots total_on_target_shots  total_shots   
##  Min.   : 1.0   Min.   : 1.00          Min.   : 1.000        Min.   : 5.00  
##  1st Qu.:10.0   1st Qu.: 8.00          1st Qu.: 6.000        1st Qu.:20.00  
##  Median :19.5   Median :10.00          Median : 8.000        Median :23.00  
##  Mean   :19.5   Mean   : 9.97          Mean   : 8.465        Mean   :23.79  
##  3rd Qu.:29.0   3rd Qu.:12.00          3rd Qu.:10.000        3rd Qu.:27.00  
##  Max.   :38.0   Max.   :22.00          Max.   :23.000        Max.   :46.00  
##                                                                             
##  total_blocked_shots total_corners    total_throw_ins total_pass_success
##  Min.   : 0.000      Min.   : 1.000   Min.   :16.00   Min.   :100.0     
##  1st Qu.: 4.000      1st Qu.: 7.000   1st Qu.:37.00   1st Qu.:146.0     
##  Median : 5.000      Median :10.000   Median :44.00   Median :154.0     
##  Mean   : 5.386      Mean   : 9.757   Mean   :44.35   Mean   :153.3     
##  3rd Qu.: 7.000      3rd Qu.:12.000   3rd Qu.:51.00   3rd Qu.:162.0     
##  Max.   :16.000      Max.   :42.000   Max.   :86.00   Max.   :183.0     
##                                                                         
##  total_aerials_won total_clearances  total_fouls    total_yellow_cards
##  Min.   : 4.0      Min.   : 11.00   Min.   : 8.00   Min.   : 0.000    
##  1st Qu.:24.0      1st Qu.: 32.00   1st Qu.:23.00   1st Qu.: 4.000    
##  Median :32.0      Median : 39.00   Median :27.00   Median : 5.000    
##  Mean   :33.8      Mean   : 40.22   Mean   :27.68   Mean   : 5.172    
##  3rd Qu.:42.0      3rd Qu.: 47.00   3rd Qu.:32.00   3rd Qu.: 7.000    
##  Max.   :95.0      Max.   :102.00   Max.   :52.00   Max.   :13.000    
##                                                                       
##  total_second_yellow_cards total_red_cards 
##  Min.   :0.0000            Min.   :0.0000  
##  1st Qu.:0.0000            1st Qu.:0.0000  
##  Median :0.0000            Median :0.0000  
##  Mean   :0.1404            Mean   :0.0943  
##  3rd Qu.:0.0000            3rd Qu.:0.0000  
##  Max.   :2.0000            Max.   :3.0000  
## 



4 ANÁLISIS EXPLORATORIO DE DATOS (EDA)



4.1 VARIABLES CUALITATIVAS


Las variables cualitativas de este data set son las siguientes:

  • Home Team: Equipo local
  • Away Team: Equipo visitante
  • Score: Resultado 2-1 (eliminado en la fase de limpiado)
  • Half Time Score: Resultado al descanso 1-1 (eliminado en la fase de limpiado)
  • score: Resultado 1 X 2


4.1.1 RESUMEN NUMERICO


Exploramos los partidos que ha jugado cada equipo, nustra pretensión es comprobar que equipos han estado más años en primera división.

matches <- as.data.frame(table(train$Home_Team) + table(train$Away_Team)) %>% arrange(desc(Freq))
kable(matches, "pipe", align = "ll")
Var1 Freq
ATHLETIC 228
ATLETICO MADRID 228
BARCELONA 228
CELTA 228
EIBAR 228
ESPANYOL 228
REAL MADRID 228
REAL SOCIEDAD 228
SEVILLA FC 228
VALENCIA 228
VILLARREAL 228
GETAFE 190
LEVANTE 190
REAL BETIS 190
ALAVÉS 152
DEPORTIVO 152
GRANADA 152
LEGANÉS 152
MÁLAGA 152
LAS PALMAS 114
RAYO VALLECANO 114
GIJÓN 76
GIRONA 76
OSASUNA 76
VALLADOLID 76
ALMERÍA 38
CÓRDOBA 38
ELCHE 38
HUESCA 38
MALLORCA 38
CÁDIZ CF 0


Número y proporción de victorias, derrotas y empates.

kable(table(train$score), align = "ll")
Var1 Freq
1 1056
x 573
2 651
kable(prop.table(table(train$score))*100, align = "ll")
Var1 Freq
1 46.31579
x 25.13158
2 28.55263


Aquí observamos cuantos partidos han ganado, empatado y perdido cada equipo. Primero como equipo local y después como equipo visitante.

kable(with(train, table(Home_Team, score)),align = "llll")
1 x 2
ALAVÉS 30 23 23
ALMERÍA 3 7 9
ATHLETIC 56 34 24
ATLETICO MADRID 82 23 9
BARCELONA 94 13 7
CÁDIZ CF 0 0 0
CELTA 47 34 33
CÓRDOBA 1 6 12
DEPORTIVO 20 25 31
EIBAR 48 24 42
ELCHE 6 3 10
ESPANYOL 46 31 37
GETAFE 40 25 30
GIJÓN 12 8 18
GIRONA 11 9 18
GRANADA 24 22 30
HUESCA 5 6 8
LAS PALMAS 21 13 23
LEGANÉS 26 23 27
LEVANTE 35 29 31
MÁLAGA 30 17 29
MALLORCA 8 3 8
OSASUNA 9 14 15
RAYO VALLECANO 21 12 24
REAL BETIS 39 26 30
REAL MADRID 86 16 12
REAL SOCIEDAD 52 28 34
SEVILLA FC 74 25 15
VALENCIA 60 34 20
VALLADOLID 10 15 13
VILLARREAL 60 25 29
kable(with(train, table(Away_Team, score)),align = "llll")
1 x 2
ALAVÉS 42 12 22
ALMERÍA 13 1 5
ATHLETIC 53 29 32
ATLETICO MADRID 24 35 55
BARCELONA 16 26 72
CÁDIZ CF 0 0 0
CELTA 58 30 26
CÓRDOBA 12 5 2
DEPORTIVO 37 30 9
EIBAR 56 35 23
ELCHE 9 5 5
ESPANYOL 58 31 25
GETAFE 45 27 23
GIJÓN 22 11 5
GIRONA 16 10 12
GRANADA 46 17 13
HUESCA 11 6 2
LAS PALMAS 40 11 6
LEGANÉS 44 19 13
LEVANTE 57 20 18
MÁLAGA 45 18 13
MALLORCA 15 3 1
OSASUNA 21 9 8
RAYO VALLECANO 35 11 11
REAL BETIS 51 20 24
REAL MADRID 22 22 70
REAL SOCIEDAD 53 27 34
SEVILLA FC 48 29 37
VALENCIA 48 29 37
VALLADOLID 18 11 9
VILLARREAL 41 34 39


Lo representamos mediante porcentajes % de victorias, derrotas y empates de cada equipo. Primero como equipo local y después como equipo visitante.

kable(round(t((prop.table(with(train, table(score, Home_Team)), margin = 2)))*100,2), align = "llll")
1 x 2
ALAVÉS 39.47 30.26 30.26
ALMERÍA 15.79 36.84 47.37
ATHLETIC 49.12 29.82 21.05
ATLETICO MADRID 71.93 20.18 7.89
BARCELONA 82.46 11.40 6.14
CÁDIZ CF NaN NaN NaN
CELTA 41.23 29.82 28.95
CÓRDOBA 5.26 31.58 63.16
DEPORTIVO 26.32 32.89 40.79
EIBAR 42.11 21.05 36.84
ELCHE 31.58 15.79 52.63
ESPANYOL 40.35 27.19 32.46
GETAFE 42.11 26.32 31.58
GIJÓN 31.58 21.05 47.37
GIRONA 28.95 23.68 47.37
GRANADA 31.58 28.95 39.47
HUESCA 26.32 31.58 42.11
LAS PALMAS 36.84 22.81 40.35
LEGANÉS 34.21 30.26 35.53
LEVANTE 36.84 30.53 32.63
MÁLAGA 39.47 22.37 38.16
MALLORCA 42.11 15.79 42.11
OSASUNA 23.68 36.84 39.47
RAYO VALLECANO 36.84 21.05 42.11
REAL BETIS 41.05 27.37 31.58
REAL MADRID 75.44 14.04 10.53
REAL SOCIEDAD 45.61 24.56 29.82
SEVILLA FC 64.91 21.93 13.16
VALENCIA 52.63 29.82 17.54
VALLADOLID 26.32 39.47 34.21
VILLARREAL 52.63 21.93 25.44
kable(round(t((prop.table(with(train, table(score, Away_Team)), margin = 2)))*100,2), align = "llll")
1 x 2
ALAVÉS 55.26 15.79 28.95
ALMERÍA 68.42 5.26 26.32
ATHLETIC 46.49 25.44 28.07
ATLETICO MADRID 21.05 30.70 48.25
BARCELONA 14.04 22.81 63.16
CÁDIZ CF NaN NaN NaN
CELTA 50.88 26.32 22.81
CÓRDOBA 63.16 26.32 10.53
DEPORTIVO 48.68 39.47 11.84
EIBAR 49.12 30.70 20.18
ELCHE 47.37 26.32 26.32
ESPANYOL 50.88 27.19 21.93
GETAFE 47.37 28.42 24.21
GIJÓN 57.89 28.95 13.16
GIRONA 42.11 26.32 31.58
GRANADA 60.53 22.37 17.11
HUESCA 57.89 31.58 10.53
LAS PALMAS 70.18 19.30 10.53
LEGANÉS 57.89 25.00 17.11
LEVANTE 60.00 21.05 18.95
MÁLAGA 59.21 23.68 17.11
MALLORCA 78.95 15.79 5.26
OSASUNA 55.26 23.68 21.05
RAYO VALLECANO 61.40 19.30 19.30
REAL BETIS 53.68 21.05 25.26
REAL MADRID 19.30 19.30 61.40
REAL SOCIEDAD 46.49 23.68 29.82
SEVILLA FC 42.11 25.44 32.46
VALENCIA 42.11 25.44 32.46
VALLADOLID 47.37 28.95 23.68
VILLARREAL 35.96 29.82 34.21


4.1.2 VISUALIZACION VARIABLES CUALITATIVAS


Se puede apreciar que jugar en casa es un factor importante para ganar (aproximadamente la mitad de partidos los gana el de casa).

ggplot(train, aes(score, fill = score)) + geom_bar() + scale_fill_manual(values = c("limegreen", "lightblue", "indianred")) + labs(x = "Resultado", y = "Nº de resultados", title = "Nº de victorias Local / Visitante / Empate") + theme(plot.title = element_text(hjust = 0.5))


Aproximadamente el 46% de los equipos que juegan en casa ganan.

a <- train %>% group_by(score) %>% count(score)
b <- round(as.double(prop.table(table(train$score))*100,2), digits = 2)
datos <- a$n
pie3D(datos, col = c("limegreen", "lightblue", "indianred"),  labels = b, explode = 0.05)


A continuación representamos mediante gráficos de barras la cantidad de partidos que juega cada equipo como local y como visitante en las 6 temporadas sometidas a estudio. Se puede apreciar claramente como hay un grupo de equipos que han jugado todos los partidos y por lo tanto nunca han descendido de categoría. Estos son: ATHLETIC, ATLETICO MADRID, BARCELONA, CELTA, EIBAR, ESPANYOL, REAL MADRID, REAL SOCIEDAD, SEVILLA FC, VALENCIA y VILLARREAL.

ggplot(train, aes(Home_Team, color = Home_Team, fill = Home_Team)) + geom_bar() + coord_flip() + labs(x = "Equipo", y = "Nº de partidos", title = "Nº de partidos como Local")+ theme(plot.title = element_text(hjust = 0.5))


ggplot(train, aes(Away_Team, color = Away_Team, fill = Away_Team)) + geom_bar() + coord_flip() + labs(x = "Equipo", y = "Nº de partidos", title = "Nº de partidos como Visitante")+ theme(plot.title = element_text(hjust = 0.5))


En este otro gráfico se pretende representar, por equipo, el número de victorias, derrotas y empates cuando se juega como local y cuando se juega como visitante. se puede apreciar como hay equipos que destacan en victorias jugando como local, ATLETICO MADRID, BARCELONA, REAL MADRID, SEVILLA FC. Además ATLETICO MADRID, BARCELONA, REAL MADRID también lo hacen como visitantes.

En cambio HUESCA, ELCHE, CORDOBA, MALLORCA y ALMERIA destacan justo por lo contrario, tiene un escaso número de victorias como equipo local y como visitante.

ggplot(train, aes(x = Home_Team, color = score, fill = score)) + geom_bar() + facet_wrap(~score) + coord_flip() + labs(x = "Equipo", y = "1    X    2", title = "Nº de   Victorias  -  Empates  -  Derrotas  como EQ. LOCAL")+ theme(plot.title = element_text(hjust = 0.5))


ggplot(train, aes(x = Away_Team, color = score, fill = score)) + geom_bar() + facet_wrap(~score) + coord_flip() + labs(x = "Equipo", y = "1    X    2", title = "Nº de   Victorias  -  Empates  -  Derrotas  como EQ. VISITANTE")+ theme(plot.title = element_text(hjust = 0.5))


4.2 VARIABLES CUANTITATIVAS

4.2.1 RESUMEN NUMERICO


POSESIÓN

summary(train$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   19.00   44.00   52.00   51.68   59.00   83.00
summary(train$`Away_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   17.00   41.00   48.00   48.32   56.00   81.00


TIROS

No puerta

summary(train$Home_Team_Off_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   4.000   5.000   5.635   7.000  18.000
summary(train$Away_Team_Off_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   3.000   4.000   4.336   6.000  14.000
summary(train$total_off_target_shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    1.00    8.00   10.00    9.97   12.00   22.00


A puerta

summary(train$Home_Team_On_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   3.000   4.000   4.757   6.000  17.000
summary(train$Away_Team_On_Target_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   3.000   3.708   5.000  13.000
summary(train$total_on_target_shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   1.000   6.000   8.000   8.465  10.000  23.000


Total

summary(train$Home_Team_Total_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    2.00   10.00   13.00   13.36   16.00   33.00
summary(train$Away_Team_Total_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00    7.00   10.00   10.43   13.00   28.00
summary(train$total_shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    5.00   20.00   23.00   23.79   27.00   46.00


BLOQUEOS

summary(train$Home_Team_Blocked_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   3.000   2.978   4.000  12.000
summary(train$Away_Team_Blocked_Shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.408   3.000  11.000
summary(train$total_blocked_shots)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   4.000   5.000   5.386   7.000  16.000


CORNERS

summary(train$Home_Team_Corners)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   3.000   5.000   5.556   7.000  20.000
summary(train$Away_Team_Corners)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   4.000   4.202   6.000  32.000
summary(train$total_corners)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   1.000   7.000  10.000   9.757  12.000  42.000


CENTROS

summary(train$Home_Team_Throw_Ins)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    5.00   18.00   22.00   22.76   27.00   49.00
summary(train$Away_Team_Throw_Ins)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    3.00   17.00   21.00   21.59   26.00   45.00
summary(train$total_throw_ins)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   16.00   37.00   44.00   44.35   51.00   86.00


PASES

summary(train$`Home_Team_Pass_Success_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   46.00   73.00   78.00   77.64   83.00   93.00
summary(train$`Away_Team_Pass_Success_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    41.0    71.0    77.0    75.7    82.0    93.0
summary(train$total_pass_success)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   100.0   146.0   154.0   153.3   162.0   183.0


BALONES AEREOS

summary(train$Home_Team_Aerials_Won)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    2.00   12.00   16.00   17.12   22.00   50.00
summary(train$Away_Team_Aerials_Won)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00   11.00   16.00   16.68   21.00   53.00
summary(train$total_aerials_won)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##     4.0    24.0    32.0    33.8    42.0    95.0


DESPEJES

summary(train$Home_Team_Clearances)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    1.00   12.00   17.00   18.01   23.00   61.00
summary(train$Away_Team_Clearances)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    2.00   15.00   21.00   22.21   28.00   63.00
summary(train$total_clearances)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   11.00   32.00   39.00   40.22   47.00  102.00


FALTAS

summary(train$Home_Team_Fouls)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    1.00   11.00   14.00   13.82   17.00   33.00
summary(train$Away_Team_Fouls)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00   11.00   14.00   13.86   17.00   30.00
summary(train$total_fouls)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    8.00   23.00   27.00   27.68   32.00   52.00


TARJETAS AMARILLAS

summary(train$Home_Team_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.465   3.000   8.000
summary(train$Away_Team_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.000   3.000   2.707   4.000   8.000
summary(train$total_yellow_cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   4.000   5.000   5.172   7.000  13.000


SEGUNDAS TARJETAS AMARILLAS

summary(train$Home_Team_Second_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.05833 0.00000 2.00000
summary(train$Away_Team_Second_Yellow_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.08202 0.00000 2.00000
summary(train$total_second_yellow_cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.0000  0.0000  0.0000  0.1404  0.0000  2.0000


TARJETAS ROJAS

summary(train$Home_Team_Red_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.04561 0.00000 2.00000
summary(train$Away_Team_Red_Cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
## 0.00000 0.00000 0.00000 0.04868 0.00000 2.00000
summary(train$total_red_cards)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.0000  0.0000  0.0000  0.0943  0.0000  3.0000


GOLES

summary(train$Home_Team_Goals_Scored)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   1.000   1.543   2.000  10.000
summary(train$Away_Team_Goals_Scored)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   0.000   1.000   1.141   2.000   8.000
summary(train$goals)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.000   2.000   2.684   4.000  12.000


4.2.2 VISUALIZACION VARIABLES CUANTITATIVAS


POSESIÓN

Histograma con curva de densidad sobre la posesión del equipo local.

ggplot(train, aes(`Home_Team_Possession_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'orange') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica % Posesión EQ. LOCAL", x="% de Posesión", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de posesión del equipo local respecto al resultado 1 X 2.

ggplot(train,aes(score ,`Home_Team_Possession_%`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'orange') + labs(title="Gráfica Pep", x="resultado", y="posesión local") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre la posesión del equipo visitante

ggplot(train, aes(`Away_Team_Possession_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'orange') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica % Posesión EQ. VISITANTE", x="% de Posesión", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de posesión del equipo visitante respecto al resultado 1 X 2.

ggplot(train,aes(score ,`Away_Team_Possession_%`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'orange') + labs(title="Gráfica Pep", x="resultado", y="posesión visitante") + theme(plot.title=element_text(hjust = 0.5))


TIROS

TOTALES

Histograma con curva de densidad sobre el total de tiros por partido.

ggplot(train, aes(`total_shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales por partido", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de tiros totales respecto al resultado 1 X 2. En los partidos el número total de disparos está bastante igualado con independencia de la victoria, derrota o empate.

ggplot(train,aes(score , total_shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="Media de disparos por partido", x="resultado", y="disparos") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tiros del equipo local por partido.

ggplot(train, aes(`Home_Team_Total_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales por partido EQ. LOCAL", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2. El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)

ggplot(train,aes(score ,Home_Team_Total_Shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. LOCAL por partido", x="resultado", y="tiros local") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tiros del equipo visitante por partido.

ggplot(train, aes(`Away_Team_Total_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales por partido EQ. VISITANTE", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2. El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)

ggplot(train,aes(score ,Away_Team_Total_Shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. VISITANTE por partido", x="resultado", y="tiros local") + theme(plot.title=element_text(hjust = 0.5))

A PUERTA

Histograma con curva de densidad sobre el total de tiros por partido.

ggplot(train, aes(`total_on_target_shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales a puerta por partido", x="tiros a puerta", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de tiros totales a puerta respecto al resultado 1 X 2.

ggplot(train,aes(score , total_on_target_shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="Media de disparos a puerta por partido", x="resultado", y="disparos a puerta") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tiros del equipo local por partido.

ggplot(train, aes(`Home_Team_On_Target_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales a puerta por partido EQ. LOCAL", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2.

ggplot(train,aes(score ,`Home_Team_On_Target_Shots`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. LOCAL por partido", x="resultado", y="tiros local a puerta") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tiros del equipo visitante por partido.

ggplot(train, aes(`Away_Team_On_Target_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'pink') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros totales a puerta por partido EQ. VISITANTE", x="tiros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Porcentaje de tiros totales del equipo local respecto al resultado 1 X 2. El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)

ggplot(train,aes(score ,`Away_Team_On_Target_Shots`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'pink') + labs(title="media de tiros EQ. VISITANTE por partido", x="resultado", y="tiros local") + theme(plot.title=element_text(hjust = 0.5))

Por motivos de simplicidad en el análisis NO hacemos el mismo ejercicio para los tiros que no van a puerta.


BLOQUEOS

Histograma con curva de densidad sobre el total de tiros bloqueados por partido.

ggplot(train, aes(`total_blocked_shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'grey') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros bloqueados totales", x="tiros bloqueados", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Bloqueos totales respecto al resultado 1 X 2.

ggplot(train,aes(score ,total_blocked_shots)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = "grey") + labs(title="Media de tiros bloqueados por partido", x="resultado", y="tiros bloqueados") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tiros bloqueados por partido del equipo local.

ggplot(train, aes(`Home_Team_Blocked_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'grey') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros bloqueados totales EQ. LOCAL", x="tiros bloqueados eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tiros bloqueados por partido del equipo visitante.

ggplot(train, aes(`Away_Team_Blocked_Shots`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'grey') + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tiros bloqueados totales EQ. VISITANTE", x="tiros bloqueados eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


CORNERS

Histograma con curva de densidad sobre el total de corners por partido.

ggplot(train, aes(`total_corners`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'blue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica corners totales", x="corners", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Corners totales respecto al resultado 1 X 2. El numero de corners no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de corners está muy repartido

ggplot(train,aes(score ,total_corners)) +  geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'blue') + labs(title="Media de corners por partido", x="resultado", y="corners") +  theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de corners por partido del equipo local.

ggplot(train, aes(`Home_Team_Corners`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'blue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica corners totales EQ. LOCAL", x="tiros bloqueados eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de corners por partido del equipo visitante.

ggplot(train, aes(`Away_Team_Corners`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'blue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica corners totales EQ. VISITANTE", x="tiros bloqueados eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


CENTROS

Histograma con curva de densidad sobre el total de centros por partido.

ggplot(train, aes(`total_throw_ins`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'lightblue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica centros totales", x="centros", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Centros totales respecto al resultado 1 X 2. El numero de centros no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de centros está muy repartido.

ggplot(train,aes(score ,total_throw_ins)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'lightblue') + labs(title="Media de centros por partido", x="resultado", y="centros") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de centros por partido del equipo local.

ggplot(train, aes(`Home_Team_Throw_Ins`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'lightblue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica centros totales EQ. LOCAL", x="centros eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de centros por partido del equipo visitante.

ggplot(train, aes(`Away_Team_Throw_Ins`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = 'lightblue') + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica centros totales EQ. VISITANTE", x="centros eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


PASES

Histograma con curva de densidad sobre el total de pases exitosos por partido.

ggplot(train, aes(`total_pass_success`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "white") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica pases exitosos totales", x="pases exitosos", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Pases totales respecto al resultado 1 X 2. El numero de centros no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de centros está muy repartido.

ggplot(train,aes(score ,`total_pass_success`)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = "white") + labs(title="Media de pases exitosos por partido", x="resultado", y="pases exitosos") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de centros por partido del equipo local.

ggplot(train, aes(`Home_Team_Pass_Success_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "white") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica pases exitosos totales EQ. LOCAL", x="pases exitosos eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de centros por partido del equipo visitante.

ggplot(train, aes(`Away_Team_Pass_Success_%`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "white") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica pases exitosos totales EQ. VISITANTE", x="pases exitosos eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


BALONES AEREOS

Histograma con curva de densidad sobre el total de balones aéreos ganadoss por partido.

ggplot(train, aes(`total_aerials_won`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "brown") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica balones aéreos ganados totales", x="balones aéreos ganados", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Balones aéreos ganados totales respecto al resultado 1 X 2. El número de duelos aereos no parece un factor determinante en la victoria.

ggplot(train,aes(score ,total_aerials_won)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = "brown") + labs(title="Media de balones aéreos ganados por partido", x="resultado", y="duelos aereos") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de centros por partido del equipo local.

ggplot(train, aes(`Home_Team_Aerials_Won`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "brown") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica balones aéreos ganados totales EQ. LOCAL", x="pases exitosos eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de centros por partido del equipo visitante.

ggplot(train, aes(`Away_Team_Aerials_Won`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "brown") + geom_density(alpha=.3, fill = "yellow") + labs(title="Gráfica balones aéreos ganados totales EQ. VISITANTE", x="pases exitosos eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


DESPEJES

Histograma con curva de densidad sobre el total de despejes por partido.

ggplot(train, aes(`total_clearances`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightgreen") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica despejes totales", x="despejes", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Despejes totales respecto al resultado 1 X 2. El número de despejes no parece un factor determinante en la victoria incluso parece que a mayor número de despejes medios el partido parece más probable que acabe en empate

ggplot(train,aes(score ,total_clearances)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'lightgreen') + labs(title="Media de despejes por partido", x="resultado", y="despejes") +  theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de despejes del equipo local.

ggplot(train, aes(`Home_Team_Clearances`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightgreen") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica despejes totales EQ. LOCAL", x="despejes eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de despejes del equipo visitante.

ggplot(train, aes(`Away_Team_Clearances`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightgreen") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica despejes totales EQ. VISITANTE", x="despejes eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


FALTAS

Histograma con curva de densidad sobre el total de faltas por partido.

ggplot(train, aes(`total_fouls`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightyellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica faltas totales", x="faltas", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Faltas totales respecto al resultado 1 X 2. El número de faltas no parece un factor determinante.

ggplot(train,aes(score ,total_fouls)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'lightyellow') + labs(title="Media de faltas por partido", x="resultado", y="faltas") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de faltas del equipo local.

ggplot(train, aes(`Home_Team_Fouls`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightyellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica faltas totales EQ. LOCAL", x="faltas eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total faltas del equipo visitante.

ggplot(train, aes(`Away_Team_Fouls`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "lightyellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica faltas totales EQ. VISITANTE", x="faltas eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


TARJETAS AMARILLAS

Histograma con curva de densidad sobre el total de tarjetas amarillas por partido.

ggplot(train, aes(`total_yellow_cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "yellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tarjetas amarillas totales", x="tarjetas amarillas", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Tarjetas amarillas totales respecto al resultado 1 X 2. El numero de tarjetas amarillas no parece un factor determinante.

ggplot(train,aes(score ,total_yellow_cards)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'yellow') + labs(title="Media de amarillas por partido", x="resultado", y="amarillas") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tarjetas amarillas del equipo local.

ggplot(train, aes(`Home_Team_Yellow_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "yellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tarjetas amarillas totales EQ. LOCAL", x="tarjetas amarillas eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total tarjetas amarillas del equipo visitante.

ggplot(train, aes(`Away_Team_Yellow_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "yellow") + geom_density(alpha=.3, fill = "blue") + labs(title="Gráfica tarjetas amarillas totales EQ. VISITANTE", x="tarjetas amarillas eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


TARJETAS ROJAS

Histograma con curva de densidad sobre el total de tarjetas rojas por partido.

ggplot(train, aes(`total_red_cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "red") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica tarjetas rojas totales", x="tarjetas rojas", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Rojas totales respecto al resultado 1 X 2. El numero de tarjetas rojas no parece un factor determinante.

ggplot(train,aes(score ,total_red_cards)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'red') + labs(title="Media de rojas por partido", x="resultado", y="rojas") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de tarjetas rojas del equipo local.

ggplot(train, aes(`Home_Team_Red_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "red") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica tarjetas rojas totales EQ. LOCAL", x="tarjetas rojas eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total tarjetas rojas del equipo visitante.

ggplot(train, aes(`Away_Team_Red_Cards`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "red") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica tarjetas rojas totales EQ. VISITANTE", x="tarjetas rojas eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))


GOLES

Histograma con curva de densidad sobre el total de tarjetas rojas por partido.

ggplot(train, aes(`goals`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "limegreen") + geom_density(alpha=.3, fill = "red") + labs(title="Gráfica goles totales", x="goles", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

En los partidos con victorias locales hay más goles de media que en los que gana el visitante (y bastante más que en los que hay empate). Por tanto, un partido con más goles es más probable que no acabe en empate.

ggplot(train,aes(score ,goals, fill = score)) + geom_bar(position = "dodge", stat = "summary", fun = "mean") + scale_fill_manual(values = c("limegreen", "lightblue", "indianred")) + labs(title="Media de goles por partido", x="resultado", y="goles") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total de goles del equipo local.

ggplot(train, aes(`Home_Team_Goals_Scored`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "limegreen") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica goles totales EQ. LOCAL", x="goles eq. local", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Histograma con curva de densidad sobre el total goles del equipo visitante.

ggplot(train, aes(`Away_Team_Goals_Scored`)) + geom_histogram(aes(y=..density..), position = "dodge", fun = "sum",color = 'black', fill = "limegreen") + geom_density(alpha=.3, fill = "green") + labs(title="Gráfica goles totales EQ. VISITANTE", x="goles eq. visitante", y="Cantidad") + theme(plot.title=element_text(hjust = 0.5))

Cuando el equipo local gana, mayor es su media de goles. Es decir, a mas goles, mas victorias. #JUNTAR ESTA GRAFICA CON LA ANTERIOR (cada columna coloreada con los goles locales y visitantes)

ggplot(train,aes(score ,Home_Team_Goals_Scored, Away_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'green') + labs(title="media de goles EQ. LOCAL por partido", x="resultado", y="goles local") + theme(plot.title=element_text(hjust = 0.5))

Cuando el equipo local pierde, mayor es la media de goles del visitante. Es decir, a mas goles encajados, mas derrotas (obvio pero habia que comprobarlo)

ggplot(train,aes(score ,Away_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'green') + labs(title="media de goles EQ. VISITANTE por partido", x="resultado", y="goles visitante") + theme(plot.title=element_text(hjust = 0.5))

ggplot(train, aes(x = goals, fill = score)) + geom_dotplot(binwidth = 0.1)


GRÁFICOS DOTPLOT POR AÑO / JORNADA


goles_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_goles = sum(goals)))
tiros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros = sum(total_shots)))
tiros_block_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros_bloqueados = sum(total_blocked_shots)))
corners_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_corners = sum(total_corners)))
centros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_throw_ins = sum(total_throw_ins)))
pases_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_pass_succ = sum(total_pass_success)))
d_aer_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_d_aer = sum(total_aerials_won)))
t_despj_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_clearances = sum(total_clearances)))
faltas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_fouls = sum(total_fouls)))
amarll_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_yellow_cards = sum(total_yellow_cards)))
rojas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_red_cards = sum(total_red_cards)))


ggplot(goles_year_jorn,  aes(x = jornada, y = total_goles)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de goles", title = "Nº de goles por jornada / Año") + theme(plot.title = element_text(hjust = 0.5)) + xlim(1,38)

ggplot(tiros_year_jorn,  aes(x = jornada, y = total_tiros)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos", title = "Nº de disparos por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(tiros_block_year_jorn,  aes(x = jornada, y = total_tiros_bloqueados)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos_bloqueados", title = "Nº de disparos bloqueados por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(corners_year_jorn,  aes(x = jornada, y = total_corners)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de corners", title = "Nº de corners por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(centros_year_jorn,  aes(x = jornada, y = total_throw_ins)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de centros", title = "Nº de centros por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(pases_year_jorn,  aes(x = jornada, y = total_pass_succ)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de pases", title = "Nº de pases por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(d_aer_year_jorn,  aes(x = jornada, y = total_d_aer)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de duelos aéreos", title = "Nº de duelos aéreos por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(t_despj_year_jorn,  aes(x = jornada, y = total_clearances)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de despejes", title = "Nº de despejes por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(faltas_year_jorn,  aes(x = jornada, y = total_fouls)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de faltas", title = "Nº de faltas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(amarll_year_jorn,  aes(x = jornada, y = total_yellow_cards)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Amarillas", title = "Nº de tarj. Amarillas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))

ggplot(rojas_year_jorn,  aes(x = jornada, y = total_red_cards)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Rojas", title = "Nº de tarj. Rojas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))


4.3 MULTIVARIANTE


train %>% select("score", "goals", "jornada", "total_fouls", "total_yellow_cards", "total_red_cards") %>%  ggpairs(aes(color = score, alpha = .5))


train %>% select("score", "goals", "total_shots","total_blocked_shots", "total_corners", "total_throw_ins", "total_pass_success", "total_aerials_won", "total_clearances") %>%  ggpairs(aes(color = score, alpha = .5))


Media de goles por partido con victoria local

sum(Victorias_casa$Home_Team_Goals_Scored,Victorias_casa$Away_Team_Goals_Scored)/nrow(Victorias_casa)
## [1] 2.980114


Media de goles por partido con victoria visitante

sum(Derrotas_casa$Home_Team_Goals_Scored,Derrotas_casa$Away_Team_Goals_Scored)/nrow(Derrotas_casa)
## [1] 2.826421


Media de goles por partido con empate

sum(Empates$Home_Team_Goals_Scored,Empates$Away_Team_Goals_Scored)/nrow(Empates)
## [1] 1.975567


Puntos promedio por partido por equipo

puntos_promedio_casa <- aggregate((home_points) ~ Home_Team, data = train, mean)

puntos_promedio_fuera <- aggregate(away_points ~ Away_Team, data = train, mean)

puntos_promedio <- data.frame(puntos_promedio_casa$Home_Team, (puntos_promedio_casa$`(home_points)` + puntos_promedio_fuera$away_points)/2)
names(puntos_promedio) <- c("Equipo", "Puntos_por_partido")
puntos_promedio
##             Equipo Puntos_por_partido
## 1           ALAVÉS          1.2565789
## 2          ALMERÍA          0.8421053
## 3         ATHLETIC          1.4342105
## 4  ATLETICO MADRID          2.0570175
## 5        BARCELONA          2.3552632
## 6            CELTA          1.2412281
## 7          CÓRDOBA          0.5263158
## 8        DEPORTIVO          0.9342105
## 9            EIBAR          1.1929825
## 10           ELCHE          1.0789474
## 11        ESPANYOL          1.2061404
## 12          GETAFE          1.2684211
## 13           GIJÓN          0.9210526
## 14          GIRONA          1.1578947
## 15         GRANADA          0.9868421
## 16          HUESCA          0.8684211
## 17      LAS PALMAS          0.9210526
## 18         LEGANÉS          1.0460526
## 19         LEVANTE          1.0947368
## 20          MÁLAGA          1.0789474
## 21        MALLORCA          0.8684211
## 22         OSASUNA          0.9736842
## 23  RAYO VALLECANO          1.0438596
## 24      REAL BETIS          1.2368421
## 25     REAL MADRID          2.2192982
## 26   REAL SOCIEDAD          1.3728070
## 27      SEVILLA FC          1.6973684
## 28        VALENCIA          1.5526316
## 29      VALLADOLID          1.0921053
## 30      VILLARREAL          1.5614035


Esta seria la clasificación con la media de puntos por partido por equipo

clasificacion_media <- arrange(puntos_promedio,desc(Puntos_por_partido))
clasificacion_media
##             Equipo Puntos_por_partido
## 1        BARCELONA          2.3552632
## 2      REAL MADRID          2.2192982
## 3  ATLETICO MADRID          2.0570175
## 4       SEVILLA FC          1.6973684
## 5       VILLARREAL          1.5614035
## 6         VALENCIA          1.5526316
## 7         ATHLETIC          1.4342105
## 8    REAL SOCIEDAD          1.3728070
## 9           GETAFE          1.2684211
## 10          ALAVÉS          1.2565789
## 11           CELTA          1.2412281
## 12      REAL BETIS          1.2368421
## 13        ESPANYOL          1.2061404
## 14           EIBAR          1.1929825
## 15          GIRONA          1.1578947
## 16         LEVANTE          1.0947368
## 17      VALLADOLID          1.0921053
## 18           ELCHE          1.0789474
## 19          MÁLAGA          1.0789474
## 20         LEGANÉS          1.0460526
## 21  RAYO VALLECANO          1.0438596
## 22         GRANADA          0.9868421
## 23         OSASUNA          0.9736842
## 24       DEPORTIVO          0.9342105
## 25           GIJÓN          0.9210526
## 26      LAS PALMAS          0.9210526
## 27          HUESCA          0.8684211
## 28        MALLORCA          0.8684211
## 29         ALMERÍA          0.8421053
## 30         CÓRDOBA          0.5263158


aggregate(Home_Team_Goals_Scored ~ Home_Team, data = train, FUN = mean) -> goles_home_team
goles_home_team
##          Home_Team Home_Team_Goals_Scored
## 1           ALAVÉS              1.0394737
## 2          ALMERÍA              1.0526316
## 3         ATHLETIC              1.4473684
## 4  ATLETICO MADRID              1.7982456
## 5        BARCELONA              3.0789474
## 6            CELTA              1.5438596
## 7          CÓRDOBA              0.6315789
## 8        DEPORTIVO              1.2631579
## 9            EIBAR              1.3771930
## 10           ELCHE              1.0000000
## 11        ESPANYOL              1.1929825
## 12          GETAFE              1.2421053
## 13           GIJÓN              1.4210526
## 14          GIRONA              1.1315789
## 15         GRANADA              1.0789474
## 16          HUESCA              1.2631579
## 17      LAS PALMAS              1.2807018
## 18         LEGANÉS              1.0131579
## 19         LEVANTE              1.3578947
## 20          MÁLAGA              1.2894737
## 21        MALLORCA              1.3157895
## 22         OSASUNA              1.2894737
## 23  RAYO VALLECANO              1.4035088
## 24      REAL BETIS              1.4000000
## 25     REAL MADRID              2.7105263
## 26   REAL SOCIEDAD              1.6140351
## 27      SEVILLA FC              1.8508772
## 28        VALENCIA              1.6491228
## 29      VALLADOLID              0.8947368
## 30      VILLARREAL              1.6666667
aggregate(Away_Team_Goals_Scored ~ Away_Team, data = train, FUN = mean) -> goles_Away_team
goles_Away_team
##          Away_Team Away_Team_Goals_Scored
## 1           ALAVÉS              0.9868421
## 2          ALMERÍA              0.7894737
## 3         ATHLETIC              0.9736842
## 4  ATLETICO MADRID              1.3947368
## 5        BARCELONA              2.2982456
## 6            CELTA              1.0877193
## 7          CÓRDOBA              0.5263158
## 8        DEPORTIVO              0.8552632
## 9            EIBAR              0.9736842
## 10           ELCHE              0.8421053
## 11        ESPANYOL              0.9736842
## 12          GETAFE              0.8947368
## 13           GIJÓN              0.7368421
## 14          GIRONA              1.1578947
## 15         GRANADA              0.9868421
## 16          HUESCA              1.0000000
## 17      LAS PALMAS              0.8596491
## 18         LEGANÉS              0.7894737
## 19         LEVANTE              0.9684211
## 20          MÁLAGA              0.7236842
## 21        MALLORCA              0.7894737
## 22         OSASUNA              0.9736842
## 23  RAYO VALLECANO              1.0350877
## 24      REAL BETIS              0.9894737
## 25     REAL MADRID              2.2105263
## 26   REAL SOCIEDAD              1.1491228
## 27      SEVILLA FC              1.2719298
## 28        VALENCIA              1.2807018
## 29      VALLADOLID              0.7894737
## 30      VILLARREAL              1.1140351
goles_por_equipo <- data.frame(goles_home_team$Home_Team,(goles_Away_team$Away_Team_Goals_Scored + goles_home_team$Home_Team_Goals_Scored)/2)
names(goles_por_equipo) <- c("equipo", "goals")
goles_por_equipo
##             equipo     goals
## 1           ALAVÉS 1.0131579
## 2          ALMERÍA 0.9210526
## 3         ATHLETIC 1.2105263
## 4  ATLETICO MADRID 1.5964912
## 5        BARCELONA 2.6885965
## 6            CELTA 1.3157895
## 7          CÓRDOBA 0.5789474
## 8        DEPORTIVO 1.0592105
## 9            EIBAR 1.1754386
## 10           ELCHE 0.9210526
## 11        ESPANYOL 1.0833333
## 12          GETAFE 1.0684211
## 13           GIJÓN 1.0789474
## 14          GIRONA 1.1447368
## 15         GRANADA 1.0328947
## 16          HUESCA 1.1315789
## 17      LAS PALMAS 1.0701754
## 18         LEGANÉS 0.9013158
## 19         LEVANTE 1.1631579
## 20          MÁLAGA 1.0065789
## 21        MALLORCA 1.0526316
## 22         OSASUNA 1.1315789
## 23  RAYO VALLECANO 1.2192982
## 24      REAL BETIS 1.1947368
## 25     REAL MADRID 2.4605263
## 26   REAL SOCIEDAD 1.3815789
## 27      SEVILLA FC 1.5614035
## 28        VALENCIA 1.4649123
## 29      VALLADOLID 0.8421053
## 30      VILLARREAL 1.3903509


#No he sido capaz de poner encima una grafica de densidad con los puntos de cada equipo 
ggplot(goles_por_equipo, aes(x = equipo, y = goals)) + geom_bar(position = "dodge", stat = "summary", fill = "darkred") + labs(title = "Comparación goles y puntos") + theme(plot.title = element_text(hjust = 0.5), axis.text.x = element_text(angle = 90))


Porcentaje medio de posesión por equipo en casa

tapply(train$`Home_Team_Possession_%`,train$`Home_Team`,mean)
##          ALAVÉS         ALMERÍA        ATHLETIC ATLETICO MADRID       BARCELONA 
##        43.86842        45.42105        51.60526        50.35965        66.31579 
##        CÁDIZ CF           CELTA         CÓRDOBA       DEPORTIVO           EIBAR 
##              NA        56.37719        51.47368        49.11842        50.61404 
##           ELCHE        ESPANYOL          GETAFE           GIJÓN          GIRONA 
##        50.05263        48.02632        44.64211        45.89474        49.52632 
##         GRANADA          HUESCA      LAS PALMAS         LEGANÉS         LEVANTE 
##        46.69737        47.31579        58.73684        45.60526        46.25263 
##          MÁLAGA        MALLORCA         OSASUNA  RAYO VALLECANO      REAL BETIS 
##        48.85526        42.89474        45.47368        54.57895        55.57895 
##     REAL MADRID   REAL SOCIEDAD      SEVILLA FC        VALENCIA      VALLADOLID 
##        60.01754        55.49123        56.39474        49.71930        47.60526 
##      VILLARREAL 
##        51.55263


Porcentaje medio de posesión por equipo fuera de casa

tapply(train$`Away_Team_Possession_%`,train$`Away_Team`,mean)
##          ALAVÉS         ALMERÍA        ATHLETIC ATLETICO MADRID       BARCELONA 
##        39.93421        42.31579        48.71930        46.68421        66.14035 
##        CÁDIZ CF           CELTA         CÓRDOBA       DEPORTIVO           EIBAR 
##              NA        52.42105        41.21053        45.23684        45.45614 
##           ELCHE        ESPANYOL          GETAFE           GIJÓN          GIRONA 
##        44.89474        44.92105        41.80000        41.42105        45.44737 
##         GRANADA          HUESCA      LAS PALMAS         LEGANÉS         LEVANTE 
##        42.86842        41.21053        53.70175        41.26316        43.56842 
##          MÁLAGA        MALLORCA         OSASUNA  RAYO VALLECANO      REAL BETIS 
##        46.07895        46.15789        40.94737        53.59649        53.07368 
##     REAL MADRID   REAL SOCIEDAD      SEVILLA FC        VALENCIA      VALLADOLID 
##        57.20175        52.43860        51.73684        48.09649        43.36842 
##      VILLARREAL 
##        46.90351


Con estos datos tan similares sacamos en conclusión que la posesión no ha influido mucho en las victorias(pobre Pep)

summary(Empates$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   21.00   45.00   52.00   51.69   59.00   81.00
summary(Victorias_casa$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   22.00   44.00   52.00   52.18   60.00   83.00
summary(Derrotas_casa$`Home_Team_Possession_%`)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   19.00   43.00   52.00   50.86   59.00   80.00


Media de goles por partido de cada equipo en su casa

ggplot(train,aes(Home_Team ,Home_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'red') + labs(title="media de goles de cada equipo como local", x="equipos", y="goles por partido") + theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))


Los equipos que más goles meten por partido, son los que más temporadas han estado en primera

ggplot(train,aes(Away_Team ,Away_Team_Goals_Scored)) + geom_bar(position = "dodge", stat = "summary", fun = "mean", color = 'black', fill = 'red') + labs(title="media de goles de cada equipo como visitante", x="equipos", y="goles por partido") + theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))


Correlación de algunas variables

pairs(train %>% select(Home_Team_Goals_Scored, Home_Team_On_Target_Shots, Home_Team_Total_Shots, `Home_Team_Possession_%`, `Home_Team_Pass_Success_%`, Home_Team_Corners, Home_Team_Throw_Ins, Home_Team_Fouls, Home_Team_Aerials_Won), pch = 21, bg = "black", col = "red")


# Esto lo borraría
hist(train$Home_Team_Goals_Scored,breaks=15, main = "Histograma de goles en casa", xlab = "goles")



# Esto lo borraría
hist(train$Away_Team_Goals_Scored,breaks=15, main = "Histograma de goles fuera", 
     xlab = "goles")

# Se marcan más goles en casa que fuera


En un 30% de las victorias de casa el equipo de casa tiró menos tiros que el de fuera

prop.table(table(Victorias_casa$Home_Team_Total_Shots > Victorias_casa$Away_Team_Total_Shots))
## 
##     FALSE      TRUE 
## 0.3001894 0.6998106


Los tiros bloqueados no influyen mucho en el resultado del partido

prop.table(table(Victorias_casa$Home_Team_Blocked_Shots > Victorias_casa$Away_Team_Blocked_Shots))
## 
##     FALSE      TRUE 
## 0.5246212 0.4753788


En las derrotas si vemos que el 43% de las veces bloquearon menos

prop.table(table(Derrotas_casa$Home_Team_Blocked_Shots > Derrotas_casa$Away_Team_Blocked_Shots))
## 
##    FALSE     TRUE 
## 0.437788 0.562212



5 REGRESION


# esta la borraría y me centraría en las principales, en las totales. Las que va a continuación.

lm_fit <- lm(Home_Team_Goals_Scored~.-Home_Team, data=train)
summary(lm_fit)
## 
## Call:
## lm(formula = Home_Team_Goals_Scored ~ . - Home_Team, data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -4.042e-13 -1.170e-15 -8.000e-17  1.150e-15  3.475e-14 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.208e-10  5.608e-11  2.154e+00 0.031384 *  
## ...1                           1.587e-16  7.326e-17  2.166e+00 0.030398 *  
## Away_TeamALMERÍA               5.513e-16  2.584e-15  2.130e-01 0.831092    
## Away_TeamATHLETIC             -4.461e-15  1.488e-15 -2.998e+00 0.002749 ** 
## Away_TeamATLETICO MADRID      -3.306e-15  1.506e-15 -2.195e+00 0.028284 *  
## Away_TeamBARCELONA            -9.209e-16  1.711e-15 -5.380e-01 0.590435    
## Away_TeamCELTA                -2.993e-17  1.511e-15 -2.000e-02 0.984201    
## Away_TeamCÓRDOBA               3.174e-15  2.582e-15  1.229e+00 0.219181    
## Away_TeamDEPORTIVO            -8.002e-16  1.645e-15 -4.860e-01 0.626722    
## Away_TeamEIBAR                -1.266e-15  1.502e-15 -8.430e-01 0.399321    
## Away_TeamELCHE                 2.124e-16  2.585e-15  8.200e-02 0.934510    
## Away_TeamESPANYOL             -6.233e-16  1.477e-15 -4.220e-01 0.673148    
## Away_TeamGETAFE               -1.369e-15  1.551e-15 -8.830e-01 0.377536    
## Away_TeamGIJÓN                 8.603e-17  1.994e-15  4.300e-02 0.965593    
## Away_TeamGIRONA                1.598e-15  1.974e-15  8.100e-01 0.418309    
## Away_TeamGRANADA               6.182e-16  1.623e-15  3.810e-01 0.703358    
## Away_TeamHUESCA                2.797e-16  2.529e-15  1.110e-01 0.911938    
## Away_TeamLAS PALMAS           -2.570e-16  1.813e-15 -1.420e-01 0.887298    
## Away_TeamLEGANÉS              -4.246e-15  1.608e-15 -2.640e+00 0.008349 ** 
## Away_TeamLEVANTE               1.868e-15  1.533e-15  1.218e+00 0.223247    
## Away_TeamMÁLAGA               -1.467e-15  1.638e-15 -8.960e-01 0.370557    
## Away_TeamMALLORCA              4.409e-16  2.548e-15  1.730e-01 0.862654    
## Away_TeamOSASUNA              -1.836e-16  1.971e-15 -9.300e-02 0.925771    
## Away_TeamRAYO VALLECANO       -2.471e-16  1.798e-15 -1.370e-01 0.890665    
## Away_TeamREAL BETIS            1.559e-15  1.583e-15  9.850e-01 0.324963    
## Away_TeamREAL MADRID          -6.222e-15  1.616e-15 -3.851e+00 0.000121 ***
## Away_TeamREAL SOCIEDAD        -4.296e-16  1.506e-15 -2.850e-01 0.775516    
## Away_TeamSEVILLA FC            1.821e-16  1.509e-15  1.210e-01 0.903962    
## Away_TeamVALENCIA             -1.830e-15  1.504e-15 -1.217e+00 0.223777    
## Away_TeamVALLADOLID            1.826e-15  1.978e-15  9.230e-01 0.355960    
## Away_TeamVILLARREAL           -8.719e-16  1.503e-15 -5.800e-01 0.561848    
## `Home_Team_Possession_%`       3.081e-17  6.976e-17  4.420e-01 0.658818    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     5.594e-16  1.153e-15  4.850e-01 0.627723    
## Home_Team_On_Target_Shots     -8.808e-16  1.154e-15 -7.630e-01 0.445286    
## Home_Team_Total_Shots         -5.364e-16  1.148e-15 -4.670e-01 0.640467    
## Home_Team_Blocked_Shots        4.946e-16  1.150e-15  4.300e-01 0.667220    
## Home_Team_Corners              3.861e-16  9.413e-17  4.102e+00 4.25e-05 ***
## Home_Team_Throw_Ins            9.759e-17  4.050e-17  2.409e+00 0.016067 *  
## `Home_Team_Pass_Success_%`     1.095e-16  7.580e-17  1.445e+00 0.148627    
## Home_Team_Aerials_Won         -4.737e-17  4.061e-17 -1.167e+00 0.243509    
## Home_Team_Clearances           1.124e-16  3.650e-17  3.080e+00 0.002095 ** 
## Home_Team_Fouls                8.635e-17  5.946e-17  1.452e+00 0.146575    
## Home_Team_Yellow_Cards        -2.207e-17  1.545e-16 -1.430e-01 0.886379    
## Home_Team_Second_Yellow_Cards -1.278e-15  8.831e-16 -1.448e+00 0.147880    
## Home_Team_Red_Cards           -1.051e-14  9.535e-16 -1.103e+01  < 2e-16 ***
## Away_Team_Off_Target_Shots     9.210e-16  9.942e-16  9.260e-01 0.354392    
## Away_Team_On_Target_Shots      3.846e-16  9.983e-16  3.850e-01 0.700115    
## Away_Team_Total_Shots         -7.232e-16  9.907e-16 -7.300e-01 0.465520    
## Away_Team_Blocked_Shots        8.486e-16  9.988e-16  8.500e-01 0.395643    
## Away_Team_Corners              1.003e-16  1.036e-16  9.680e-01 0.332978    
## Away_Team_Throw_Ins            1.858e-17  4.297e-17  4.320e-01 0.665444    
## `Away_Team_Pass_Success_%`    -4.175e-17  7.289e-17 -5.730e-01 0.566855    
## Away_Team_Aerials_Won         -8.280e-18  4.214e-17 -1.960e-01 0.844256    
## Away_Team_Clearances           2.098e-18  3.263e-17  6.400e-02 0.948740    
## Away_Team_Fouls                7.512e-17  5.826e-17  1.289e+00 0.197397    
## Away_Team_Yellow_Cards         1.652e-16  1.561e-16  1.058e+00 0.290015    
## Away_Team_Second_Yellow_Cards  8.676e-16  7.582e-16  1.144e+00 0.252623    
## Away_Team_Red_Cards            1.252e-15  9.402e-16  1.332e+00 0.182992    
## Away_Team_Goals_Scored        -1.000e+00  4.808e-16 -2.080e+15  < 2e-16 ***
## year                          -5.997e-14  2.784e-14 -2.154e+00 0.031352 *  
## scorex                         1.183e-16  6.784e-16  1.740e-01 0.861608    
## score2                         1.670e-15  9.607e-16  1.738e+00 0.082304 .  
## goals                          1.000e+00  2.693e-16  3.713e+15  < 2e-16 ***
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -1.518e-15  7.328e-16 -2.072e+00 0.038411 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 9.799e-15 on 2216 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 6.757e+29 on 63 and 2216 DF,  p-value: < 2.2e-16
#regfit_fwd <- leaps::regsubsets(Home_Team_Goals_Scored~., train, method="forward")
#for (metric in c("r2", "adjr2", "Cp", "bic")){plot(regfit_fwd, scale=metric)}

Variables más influyentes en los goles marcados: Centros, despejes, tarjetas rojas,

Regresión con todas las variables

lm_goles <- lm(goals~., data = train)
summary(lm_goles)
## 
## Call:
## lm(formula = goals ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -4.252e-14 -1.180e-15  1.100e-16  1.310e-15  3.978e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                   -1.037e-10  5.655e-11 -1.834e+00 0.066848 .  
## ...1                          -1.363e-16  7.388e-17 -1.846e+00 0.065091 .  
## Home_TeamALMERÍA              -9.591e-16  2.590e-15 -3.700e-01 0.711142    
## Home_TeamATHLETIC             -3.738e-16  1.497e-15 -2.500e-01 0.802835    
## Home_TeamATLETICO MADRID       3.007e-16  1.515e-15  1.990e-01 0.842660    
## Home_TeamBARCELONA            -2.144e-15  1.760e-15 -1.218e+00 0.223285    
## Home_TeamCELTA                -9.547e-16  1.542e-15 -6.190e-01 0.535914    
## Home_TeamCÓRDOBA              -2.002e-15  2.592e-15 -7.720e-01 0.439992    
## Home_TeamDEPORTIVO             7.998e-16  1.645e-15  4.860e-01 0.626772    
## Home_TeamEIBAR                -4.925e-16  1.526e-15 -3.230e-01 0.746983    
## Home_TeamELCHE                -2.960e-15  2.597e-15 -1.140e+00 0.254555    
## Home_TeamESPANYOL             -2.478e-15  1.482e-15 -1.672e+00 0.094599 .  
## Home_TeamGETAFE               -2.851e-15  1.560e-15 -1.827e+00 0.067830 .  
## Home_TeamGIJÓN                -4.155e-15  2.014e-15 -2.063e+00 0.039226 *  
## Home_TeamGIRONA               -5.397e-16  1.980e-15 -2.730e-01 0.785226    
## Home_TeamGRANADA              -9.466e-16  1.625e-15 -5.820e-01 0.560375    
## Home_TeamHUESCA                1.180e-15  2.545e-15  4.640e-01 0.642900    
## Home_TeamLAS PALMAS           -5.480e-15  1.855e-15 -2.954e+00 0.003171 ** 
## Home_TeamLEGANÉS              -1.753e-15  1.611e-15 -1.089e+00 0.276446    
## Home_TeamLEVANTE              -1.458e-15  1.546e-15 -9.430e-01 0.345638    
## Home_TeamMÁLAGA                5.077e-15  1.641e-15  3.094e+00 0.002002 ** 
## Home_TeamMALLORCA             -1.474e-15  2.555e-15 -5.770e-01 0.564009    
## Home_TeamOSASUNA              -3.709e-16  1.991e-15 -1.860e-01 0.852266    
## Home_TeamRAYO VALLECANO       -4.176e-15  1.805e-15 -2.314e+00 0.020782 *  
## Home_TeamREAL BETIS           -2.062e-15  1.598e-15 -1.290e+00 0.197184    
## Home_TeamREAL MADRID          -1.046e-15  1.673e-15 -6.250e-01 0.532040    
## Home_TeamREAL SOCIEDAD         3.737e-16  1.526e-15  2.450e-01 0.806617    
## Home_TeamSEVILLA FC           -1.665e-16  1.550e-15 -1.070e-01 0.914460    
## Home_TeamVALENCIA             -1.680e-16  1.521e-15 -1.110e-01 0.912015    
## Home_TeamVALLADOLID            1.864e-15  1.993e-15  9.350e-01 0.349727    
## Home_TeamVILLARREAL           -1.648e-15  1.522e-15 -1.083e+00 0.278961    
## Away_TeamALMERÍA               9.205e-15  2.588e-15  3.557e+00 0.000383 ***
## Away_TeamATHLETIC              3.958e-15  1.498e-15  2.642e+00 0.008308 ** 
## Away_TeamATLETICO MADRID      -8.607e-16  1.516e-15 -5.680e-01 0.570196    
## Away_TeamBARCELONA             5.579e-16  1.768e-15  3.160e-01 0.752331    
## Away_TeamCELTA                 6.818e-16  1.523e-15  4.480e-01 0.654362    
## Away_TeamCÓRDOBA               4.133e-16  2.589e-15  1.600e-01 0.873206    
## Away_TeamDEPORTIVO             1.370e-15  1.650e-15  8.310e-01 0.406202    
## Away_TeamEIBAR                 2.817e-15  1.513e-15  1.862e+00 0.062729 .  
## Away_TeamELCHE                -2.987e-15  2.589e-15 -1.154e+00 0.248629    
## Away_TeamESPANYOL              1.309e-15  1.481e-15  8.840e-01 0.376749    
## Away_TeamGETAFE                3.797e-16  1.557e-15  2.440e-01 0.807336    
## Away_TeamGIJÓN                 3.729e-16  1.996e-15  1.870e-01 0.851829    
## Away_TeamGIRONA                2.581e-16  1.978e-15  1.300e-01 0.896183    
## Away_TeamGRANADA               1.627e-15  1.625e-15  1.001e+00 0.316792    
## Away_TeamHUESCA               -5.483e-16  2.532e-15 -2.170e-01 0.828593    
## Away_TeamLAS PALMAS            4.558e-15  1.825e-15  2.497e+00 0.012588 *  
## Away_TeamLEGANÉS              -7.124e-16  1.610e-15 -4.420e-01 0.658262    
## Away_TeamLEVANTE               2.478e-15  1.536e-15  1.613e+00 0.106850    
## Away_TeamMÁLAGA               -7.302e-16  1.643e-15 -4.440e-01 0.656785    
## Away_TeamMALLORCA              4.265e-15  2.552e-15  1.671e+00 0.094851 .  
## Away_TeamOSASUNA              -9.294e-16  1.974e-15 -4.710e-01 0.637826    
## Away_TeamRAYO VALLECANO        3.447e-15  1.807e-15  1.908e+00 0.056577 .  
## Away_TeamREAL BETIS            2.295e-15  1.596e-15  1.438e+00 0.150706    
## Away_TeamREAL MADRID           2.442e-15  1.648e-15  1.482e+00 0.138554    
## Away_TeamREAL SOCIEDAD         2.615e-15  1.521e-15  1.719e+00 0.085709 .  
## Away_TeamSEVILLA FC            2.029e-15  1.521e-15  1.334e+00 0.182380    
## Away_TeamVALENCIA              2.030e-15  1.512e-15  1.343e+00 0.179491    
## Away_TeamVALLADOLID            8.160e-16  1.979e-15  4.120e-01 0.680191    
## Away_TeamVILLARREAL            2.426e-15  1.511e-15  1.606e+00 0.108421    
## `Home_Team_Possession_%`       2.661e-16  7.675e-17  3.467e+00 0.000537 ***
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -5.490e-17  1.160e-15 -4.700e-02 0.962264    
## Home_Team_On_Target_Shots      8.129e-16  1.160e-15  7.010e-01 0.483655    
## Home_Team_Total_Shots          1.966e-16  1.155e-15  1.700e-01 0.864902    
## Home_Team_Blocked_Shots       -4.294e-16  1.157e-15 -3.710e-01 0.710587    
## Home_Team_Corners             -1.787e-16  9.541e-17 -1.873e+00 0.061268 .  
## Home_Team_Throw_Ins            1.039e-16  4.171e-17  2.490e+00 0.012842 *  
## `Home_Team_Pass_Success_%`    -1.984e-16  8.174e-17 -2.428e+00 0.015282 *  
## Home_Team_Aerials_Won          1.748e-18  4.342e-17  4.000e-02 0.967898    
## Home_Team_Clearances          -7.912e-17  3.698e-17 -2.139e+00 0.032523 *  
## Home_Team_Fouls               -4.362e-17  6.077e-17 -7.180e-01 0.472930    
## Home_Team_Yellow_Cards         4.599e-17  1.560e-16  2.950e-01 0.768092    
## Home_Team_Second_Yellow_Cards  6.128e-17  8.899e-16  6.900e-02 0.945103    
## Home_Team_Red_Cards            6.101e-15  9.652e-16  6.321e+00 3.14e-10 ***
## Away_Team_Off_Target_Shots     5.597e-16  9.965e-16  5.620e-01 0.574360    
## Away_Team_On_Target_Shots      1.487e-15  1.001e-15  1.486e+00 0.137365    
## Away_Team_Total_Shots         -6.901e-16  9.931e-16 -6.950e-01 0.487226    
## Away_Team_Blocked_Shots        6.828e-16  1.001e-15  6.820e-01 0.495242    
## Away_Team_Corners             -6.942e-17  1.044e-16 -6.650e-01 0.506168    
## Away_Team_Throw_Ins            4.391e-18  4.458e-17  9.800e-02 0.921561    
## `Away_Team_Pass_Success_%`     1.144e-16  7.615e-17  1.502e+00 0.133206    
## Away_Team_Aerials_Won          2.425e-17  4.290e-17  5.650e-01 0.571987    
## Away_Team_Clearances          -2.391e-16  3.404e-17 -7.023e+00 2.90e-12 ***
## Away_Team_Fouls               -1.750e-16  6.009e-17 -2.913e+00 0.003616 ** 
## Away_Team_Yellow_Cards         1.858e-16  1.586e-16  1.171e+00 0.241533    
## Away_Team_Second_Yellow_Cards  4.049e-16  7.679e-16  5.270e-01 0.598062    
## Away_Team_Red_Cards           -3.413e-16  9.455e-16 -3.610e-01 0.718154    
## Home_Team_Goals_Scored         1.000e+00  2.730e-16  3.663e+15  < 2e-16 ***
## Away_Team_Goals_Scored         1.000e+00  3.085e-16  3.242e+15  < 2e-16 ***
## year                           5.149e-14  2.808e-14  1.834e+00 0.066819 .  
## scorex                        -6.430e-16  6.855e-16 -9.380e-01 0.348277    
## score2                        -1.171e-15  9.729e-16 -1.204e+00 0.228794    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                        1.324e-15  7.390e-16  1.792e+00 0.073343 .  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 9.794e-15 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 7.5e+29 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_disparos <- lm(total_shots~., data = train)
summary(lm_disparos)
## 
## Call:
## lm(formula = total_shots ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -2.785e-13 -1.070e-14  4.200e-15  1.890e-14  6.871e-12 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                   -1.903e-09  8.797e-10 -2.164e+00  0.03061 *  
## ...1                          -2.497e-15  1.149e-15 -2.173e+00  0.02989 *  
## Home_TeamALMERÍA              -2.646e-14  4.029e-14 -6.570e-01  0.51138    
## Home_TeamATHLETIC             -2.397e-15  2.329e-14 -1.030e-01  0.91805    
## Home_TeamATLETICO MADRID      -8.469e-15  2.357e-14 -3.590e-01  0.71934    
## Home_TeamBARCELONA            -2.508e-14  2.738e-14 -9.160e-01  0.35977    
## Home_TeamCELTA                -7.377e-15  2.399e-14 -3.080e-01  0.75847    
## Home_TeamCÓRDOBA              -8.556e-16  4.032e-14 -2.100e-02  0.98307    
## Home_TeamDEPORTIVO            -4.844e-15  2.558e-14 -1.890e-01  0.84986    
## Home_TeamEIBAR                -9.743e-15  2.374e-14 -4.100e-01  0.68160    
## Home_TeamELCHE                -1.443e-14  4.040e-14 -3.570e-01  0.72109    
## Home_TeamESPANYOL             -3.681e-16  2.305e-14 -1.600e-02  0.98726    
## Home_TeamGETAFE               -1.341e-14  2.427e-14 -5.520e-01  0.58072    
## Home_TeamGIJÓN                -2.070e-14  3.133e-14 -6.610e-01  0.50891    
## Home_TeamGIRONA                1.272e-15  3.080e-14  4.100e-02  0.96707    
## Home_TeamGRANADA              -1.049e-14  2.529e-14 -4.150e-01  0.67818    
## Home_TeamHUESCA               -3.849e-15  3.960e-14 -9.700e-02  0.92257    
## Home_TeamLAS PALMAS           -5.839e-15  2.886e-14 -2.020e-01  0.83967    
## Home_TeamLEGANÉS              -1.105e-14  2.506e-14 -4.410e-01  0.65937    
## Home_TeamLEVANTE              -1.694e-14  2.405e-14 -7.040e-01  0.48142    
## Home_TeamMÁLAGA                7.941e-14  2.553e-14  3.111e+00  0.00189 ** 
## Home_TeamMALLORCA             -4.440e-18  3.974e-14  0.000e+00  0.99991    
## Home_TeamOSASUNA              -5.090e-15  3.098e-14 -1.640e-01  0.86951    
## Home_TeamRAYO VALLECANO       -1.262e-14  2.808e-14 -4.490e-01  0.65315    
## Home_TeamREAL BETIS           -3.354e-15  2.487e-14 -1.350e-01  0.89272    
## Home_TeamREAL MADRID          -1.843e-14  2.603e-14 -7.080e-01  0.47888    
## Home_TeamREAL SOCIEDAD        -3.037e-15  2.374e-14 -1.280e-01  0.89822    
## Home_TeamSEVILLA FC           -7.815e-15  2.411e-14 -3.240e-01  0.74582    
## Home_TeamVALENCIA             -5.715e-15  2.366e-14 -2.420e-01  0.80911    
## Home_TeamVALLADOLID            2.032e-15  3.100e-14  6.600e-02  0.94774    
## Home_TeamVILLARREAL           -6.956e-15  2.368e-14 -2.940e-01  0.76896    
## Away_TeamALMERÍA               1.617e-15  4.026e-14  4.000e-02  0.96797    
## Away_TeamATHLETIC              5.872e-14  2.331e-14  2.519e+00  0.01184 *  
## Away_TeamATLETICO MADRID      -1.423e-15  2.358e-14 -6.000e-02  0.95189    
## Away_TeamBARCELONA            -2.422e-14  2.750e-14 -8.810e-01  0.37858    
## Away_TeamCELTA                -7.690e-15  2.369e-14 -3.250e-01  0.74546    
## Away_TeamCÓRDOBA              -1.514e-14  4.028e-14 -3.760e-01  0.70706    
## Away_TeamDEPORTIVO            -4.149e-15  2.566e-14 -1.620e-01  0.87156    
## Away_TeamEIBAR                -6.707e-15  2.353e-14 -2.850e-01  0.77567    
## Away_TeamELCHE                -2.436e-14  4.027e-14 -6.050e-01  0.54529    
## Away_TeamESPANYOL             -5.490e-15  2.303e-14 -2.380e-01  0.81164    
## Away_TeamGETAFE               -3.163e-15  2.422e-14 -1.310e-01  0.89612    
## Away_TeamGIJÓN                 1.061e-15  3.105e-14  3.400e-02  0.97275    
## Away_TeamGIRONA               -4.658e-15  3.076e-14 -1.510e-01  0.87965    
## Away_TeamGRANADA              -6.892e-15  2.528e-14 -2.730e-01  0.78515    
## Away_TeamHUESCA               -2.759e-15  3.939e-14 -7.000e-02  0.94416    
## Away_TeamLAS PALMAS           -1.222e-14  2.839e-14 -4.300e-01  0.66691    
## Away_TeamLEGANÉS              -3.420e-15  2.505e-14 -1.370e-01  0.89143    
## Away_TeamLEVANTE              -1.425e-14  2.389e-14 -5.970e-01  0.55089    
## Away_TeamMÁLAGA               -6.897e-16  2.556e-14 -2.700e-02  0.97848    
## Away_TeamMALLORCA              2.873e-15  3.970e-14  7.200e-02  0.94231    
## Away_TeamOSASUNA               9.386e-15  3.071e-14  3.060e-01  0.75990    
## Away_TeamRAYO VALLECANO       -6.155e-15  2.811e-14 -2.190e-01  0.82669    
## Away_TeamREAL BETIS           -1.280e-14  2.483e-14 -5.160e-01  0.60616    
## Away_TeamREAL MADRID           1.362e-14  2.564e-14  5.310e-01  0.59520    
## Away_TeamREAL SOCIEDAD         2.650e-15  2.366e-14  1.120e-01  0.91084    
## Away_TeamSEVILLA FC           -6.062e-15  2.367e-14 -2.560e-01  0.79789    
## Away_TeamVALENCIA             -4.382e-15  2.352e-14 -1.860e-01  0.85224    
## Away_TeamVALLADOLID           -1.185e-14  3.079e-14 -3.850e-01  0.70048    
## Away_TeamVILLARREAL           -8.914e-15  2.350e-14 -3.790e-01  0.70449    
## `Home_Team_Possession_%`       1.559e-15  1.194e-15  1.305e+00  0.19186    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -6.887e-16  1.805e-14 -3.800e-02  0.96957    
## Home_Team_On_Target_Shots     -3.796e-15  1.805e-14 -2.100e-01  0.83345    
## Home_Team_Total_Shots          1.000e+00  1.797e-14  5.563e+13  < 2e-16 ***
## Home_Team_Blocked_Shots       -4.680e-16  1.800e-14 -2.600e-02  0.97926    
## Home_Team_Corners             -2.029e-16  1.484e-15 -1.370e-01  0.89126    
## Home_Team_Throw_Ins           -1.111e-15  6.488e-16 -1.712e+00  0.08697 .  
## `Home_Team_Pass_Success_%`    -2.275e-15  1.272e-15 -1.789e+00  0.07375 .  
## Home_Team_Aerials_Won         -2.163e-16  6.754e-16 -3.200e-01  0.74885    
## Home_Team_Clearances          -3.969e-16  5.753e-16 -6.900e-01  0.49030    
## Home_Team_Fouls               -7.746e-16  9.454e-16 -8.190e-01  0.41270    
## Home_Team_Yellow_Cards         1.138e-15  2.426e-15  4.690e-01  0.63914    
## Home_Team_Second_Yellow_Cards  1.409e-15  1.384e-14  1.020e-01  0.91893    
## Home_Team_Red_Cards            1.360e-13  1.502e-14  9.060e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots    -2.766e-15  1.550e-14 -1.780e-01  0.85839    
## Away_Team_On_Target_Shots      2.079e-15  1.557e-14  1.340e-01  0.89375    
## Away_Team_Total_Shots          1.000e+00  1.545e-14  6.473e+13  < 2e-16 ***
## Away_Team_Blocked_Shots       -8.861e-16  1.557e-14 -5.700e-02  0.95463    
## Away_Team_Corners             -5.089e-16  1.624e-15 -3.130e-01  0.75405    
## Away_Team_Throw_Ins           -2.886e-16  6.936e-16 -4.160e-01  0.67738    
## `Away_Team_Pass_Success_%`     1.269e-15  1.185e-15  1.072e+00  0.28397    
## Away_Team_Aerials_Won          7.110e-17  6.673e-16  1.070e-01  0.91516    
## Away_Team_Clearances          -4.433e-16  5.296e-16 -8.370e-01  0.40266    
## Away_Team_Fouls               -1.323e-15  9.348e-16 -1.415e+00  0.15710    
## Away_Team_Yellow_Cards         6.105e-16  2.467e-15  2.470e-01  0.80458    
## Away_Team_Second_Yellow_Cards -4.817e-15  1.194e-14 -4.030e-01  0.68682    
## Away_Team_Red_Cards           -1.416e-14  1.471e-14 -9.630e-01  0.33574    
## Home_Team_Goals_Scored        -3.459e-15  4.247e-15 -8.150e-01  0.41542    
## Away_Team_Goals_Scored        -3.047e-15  4.799e-15 -6.350e-01  0.52555    
## year                           9.451e-13  4.368e-13  2.164e+00  0.03059 *  
## scorex                        -1.661e-14  1.066e-14 -1.557e+00  0.11951    
## score2                        -2.460e-14  1.514e-14 -1.626e+00  0.10420    
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                        2.442e-14  1.150e-14  2.124e+00  0.03377 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.524e-13 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 3.438e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_disparos_bloqueados <- lm(total_blocked_shots~., data = train)
summary(lm_disparos_bloqueados)
## 
## Call:
## lm(formula = total_blocked_shots ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -1.926e-12 -5.730e-15 -1.550e-15  3.330e-15  4.481e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    5.499e-10  2.534e-10  2.170e+00  0.03011 *  
## ...1                           7.215e-16  3.310e-16  2.179e+00  0.02941 *  
## Home_TeamALMERÍA               5.015e-16  1.160e-14  4.300e-02  0.96553    
## Home_TeamATHLETIC              2.654e-15  6.708e-15  3.960e-01  0.69242    
## Home_TeamATLETICO MADRID       3.393e-15  6.788e-15  5.000e-01  0.61728    
## Home_TeamBARCELONA             6.123e-15  7.888e-15  7.760e-01  0.43764    
## Home_TeamCELTA                 4.945e-15  6.910e-15  7.160e-01  0.47433    
## Home_TeamCÓRDOBA               2.290e-15  1.161e-14  1.970e-01  0.84369    
## Home_TeamDEPORTIVO             4.009e-15  7.369e-15  5.440e-01  0.58653    
## Home_TeamEIBAR                 7.048e-15  6.839e-15  1.030e+00  0.30290    
## Home_TeamELCHE                 5.040e-15  1.164e-14  4.330e-01  0.66503    
## Home_TeamESPANYOL              4.324e-15  6.641e-15  6.510e-01  0.51498    
## Home_TeamGETAFE                5.901e-15  6.991e-15  8.440e-01  0.39876    
## Home_TeamGIJÓN                 6.560e-15  9.024e-15  7.270e-01  0.46730    
## Home_TeamGIRONA                3.139e-15  8.873e-15  3.540e-01  0.72357    
## Home_TeamGRANADA               4.713e-15  7.284e-15  6.470e-01  0.51770    
## Home_TeamHUESCA                3.025e-15  1.141e-14  2.650e-01  0.79088    
## Home_TeamLAS PALMAS            2.301e-16  8.312e-15  2.800e-02  0.97792    
## Home_TeamLEGANÉS               1.148e-14  7.218e-15  1.590e+00  0.11201    
## Home_TeamLEVANTE               7.010e-15  6.928e-15  1.012e+00  0.31173    
## Home_TeamMÁLAGA               -1.792e-14  7.354e-15 -2.436e+00  0.01492 *  
## Home_TeamMALLORCA              4.449e-15  1.145e-14  3.890e-01  0.69763    
## Home_TeamOSASUNA               4.948e-15  8.923e-15  5.550e-01  0.57929    
## Home_TeamRAYO VALLECANO        7.925e-15  8.088e-15  9.800e-01  0.32728    
## Home_TeamREAL BETIS            7.033e-15  7.163e-15  9.820e-01  0.32628    
## Home_TeamREAL MADRID           9.773e-15  7.498e-15  1.303e+00  0.19256    
## Home_TeamREAL SOCIEDAD         4.661e-15  6.839e-15  6.820e-01  0.49561    
## Home_TeamSEVILLA FC            3.988e-15  6.944e-15  5.740e-01  0.56583    
## Home_TeamVALENCIA              2.810e-15  6.814e-15  4.120e-01  0.68012    
## Home_TeamVALLADOLID           -1.200e-15  8.930e-15 -1.340e-01  0.89313    
## Home_TeamVILLARREAL            5.904e-15  6.821e-15  8.660e-01  0.38684    
## Away_TeamALMERÍA               1.064e-15  1.160e-14  9.200e-02  0.92693    
## Away_TeamATHLETIC             -1.929e-14  6.714e-15 -2.873e+00  0.00411 ** 
## Away_TeamATLETICO MADRID      -1.581e-15  6.792e-15 -2.330e-01  0.81600    
## Away_TeamBARCELONA             2.014e-15  7.921e-15  2.540e-01  0.79926    
## Away_TeamCELTA                -1.616e-15  6.823e-15 -2.370e-01  0.81281    
## Away_TeamCÓRDOBA               4.536e-15  1.160e-14  3.910e-01  0.69588    
## Away_TeamDEPORTIVO            -1.852e-15  7.392e-15 -2.510e-01  0.80218    
## Away_TeamEIBAR                -7.241e-15  6.779e-15 -1.068e+00  0.28553    
## Away_TeamELCHE                 4.637e-16  1.160e-14  4.000e-02  0.96811    
## Away_TeamESPANYOL             -2.852e-15  6.635e-15 -4.300e-01  0.66732    
## Away_TeamGETAFE               -5.203e-15  6.977e-15 -7.460e-01  0.45591    
## Away_TeamGIJÓN                -1.265e-15  8.944e-15 -1.410e-01  0.88757    
## Away_TeamGIRONA               -2.007e-15  8.861e-15 -2.260e-01  0.82084    
## Away_TeamGRANADA               1.555e-17  7.282e-15  2.000e-03  0.99830    
## Away_TeamHUESCA               -5.168e-15  1.135e-14 -4.550e-01  0.64884    
## Away_TeamLAS PALMAS           -3.735e-16  8.179e-15 -4.600e-02  0.96358    
## Away_TeamLEGANÉS              -4.141e-15  7.216e-15 -5.740e-01  0.56612    
## Away_TeamLEVANTE               2.750e-16  6.883e-15  4.000e-02  0.96813    
## Away_TeamMÁLAGA               -3.472e-15  7.363e-15 -4.720e-01  0.63732    
## Away_TeamMALLORCA             -4.206e-15  1.144e-14 -3.680e-01  0.71303    
## Away_TeamOSASUNA              -4.316e-15  8.845e-15 -4.880e-01  0.62562    
## Away_TeamRAYO VALLECANO       -7.268e-16  8.097e-15 -9.000e-02  0.92849    
## Away_TeamREAL BETIS            3.179e-15  7.153e-15  4.440e-01  0.65674    
## Away_TeamREAL MADRID          -1.064e-15  7.385e-15 -1.440e-01  0.88544    
## Away_TeamREAL SOCIEDAD        -3.482e-15  6.815e-15 -5.110e-01  0.60947    
## Away_TeamSEVILLA FC            1.255e-15  6.818e-15  1.840e-01  0.85396    
## Away_TeamVALENCIA              1.025e-15  6.776e-15  1.510e-01  0.87973    
## Away_TeamVALLADOLID            2.010e-15  8.870e-15  2.270e-01  0.82078    
## Away_TeamVILLARREAL            8.887e-16  6.770e-15  1.310e-01  0.89557    
## `Home_Team_Possession_%`      -2.463e-16  3.439e-16 -7.160e-01  0.47390    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     7.212e-15  5.199e-15  1.387e+00  0.16556    
## Home_Team_On_Target_Shots      7.502e-15  5.200e-15  1.443e+00  0.14927    
## Home_Team_Total_Shots         -7.080e-15  5.178e-15 -1.367e+00  0.17163    
## Home_Team_Blocked_Shots        1.000e+00  5.185e-15  1.929e+14  < 2e-16 ***
## Home_Team_Corners             -2.459e-16  4.275e-16 -5.750e-01  0.56522    
## Home_Team_Throw_Ins            3.361e-16  1.869e-16  1.799e+00  0.07221 .  
## `Home_Team_Pass_Success_%`     4.790e-16  3.663e-16  1.308e+00  0.19114    
## Home_Team_Aerials_Won          1.835e-18  1.946e-16  9.000e-03  0.99248    
## Home_Team_Clearances           5.415e-17  1.657e-16  3.270e-01  0.74392    
## Home_Team_Fouls                1.160e-16  2.723e-16  4.260e-01  0.67029    
## Home_Team_Yellow_Cards        -1.610e-16  6.989e-16 -2.300e-01  0.81787    
## Home_Team_Second_Yellow_Cards -5.309e-17  3.988e-15 -1.300e-02  0.98938    
## Home_Team_Red_Cards           -3.914e-14  4.325e-15 -9.048e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots    -2.100e-15  4.465e-15 -4.700e-01  0.63823    
## Away_Team_On_Target_Shots     -2.781e-15  4.484e-15 -6.200e-01  0.53512    
## Away_Team_Total_Shots          2.332e-15  4.450e-15  5.240e-01  0.60025    
## Away_Team_Blocked_Shots        1.000e+00  4.486e-15  2.229e+14  < 2e-16 ***
## Away_Team_Corners              1.212e-16  4.679e-16  2.590e-01  0.79564    
## Away_Team_Throw_Ins           -2.279e-17  1.998e-16 -1.140e-01  0.90918    
## `Away_Team_Pass_Success_%`    -3.832e-16  3.412e-16 -1.123e+00  0.26157    
## Away_Team_Aerials_Won         -9.635e-18  1.922e-16 -5.000e-02  0.96003    
## Away_Team_Clearances           1.675e-16  1.525e-16  1.098e+00  0.27242    
## Away_Team_Fouls                4.707e-16  2.693e-16  1.748e+00  0.08058 .  
## Away_Team_Yellow_Cards        -4.989e-16  7.106e-16 -7.020e-01  0.48271    
## Away_Team_Second_Yellow_Cards  1.377e-15  3.441e-15  4.000e-01  0.68902    
## Away_Team_Red_Cards            3.133e-15  4.237e-15  7.390e-01  0.45971    
## Home_Team_Goals_Scored         1.216e-15  1.223e-15  9.940e-01  0.32044    
## Away_Team_Goals_Scored         1.202e-15  1.382e-15  8.700e-01  0.38464    
## year                          -2.731e-13  1.258e-13 -2.170e+00  0.03009 *  
## scorex                         5.268e-15  3.072e-15  1.715e+00  0.08650 .  
## score2                         6.006e-15  4.360e-15  1.378e+00  0.16850    
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -7.076e-15  3.311e-15 -2.137e+00  0.03272 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 4.389e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 8.752e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_corners <- lm(total_corners~., data = train)
summary(lm_corners)
## 
## Call:
## lm(formula = total_corners ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -3.206e-12 -9.000e-15 -2.200e-15  5.200e-15  2.392e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    9.505e-10  4.120e-10  2.307e+00  0.02115 *  
## ...1                           1.248e-15  5.383e-16  2.319e+00  0.02048 *  
## Home_TeamALMERÍA               1.194e-15  1.887e-14  6.300e-02  0.94957    
## Home_TeamATHLETIC              1.213e-15  1.091e-14  1.110e-01  0.91149    
## Home_TeamATLETICO MADRID       2.922e-15  1.104e-14  2.650e-01  0.79120    
## Home_TeamBARCELONA             9.535e-15  1.282e-14  7.430e-01  0.45728    
## Home_TeamCELTA                 4.547e-15  1.123e-14  4.050e-01  0.68574    
## Home_TeamCÓRDOBA              -2.775e-16  1.888e-14 -1.500e-02  0.98828    
## Home_TeamDEPORTIVO             6.664e-16  1.198e-14  5.600e-02  0.95565    
## Home_TeamEIBAR                 3.006e-15  1.112e-14  2.700e-01  0.78697    
## Home_TeamELCHE                 2.951e-15  1.892e-14  1.560e-01  0.87609    
## Home_TeamESPANYOL              1.359e-15  1.080e-14  1.260e-01  0.89987    
## Home_TeamGETAFE                9.281e-15  1.137e-14  8.160e-01  0.41431    
## Home_TeamGIJÓN                 5.420e-15  1.467e-14  3.690e-01  0.71187    
## Home_TeamGIRONA               -2.779e-15  1.443e-14 -1.930e-01  0.84727    
## Home_TeamGRANADA               3.610e-15  1.184e-14  3.050e-01  0.76053    
## Home_TeamHUESCA               -5.105e-15  1.855e-14 -2.750e-01  0.78314    
## Home_TeamLAS PALMAS            6.283e-16  1.352e-14  4.600e-02  0.96293    
## Home_TeamLEGANÉS               2.634e-15  1.174e-14  2.240e-01  0.82242    
## Home_TeamLEVANTE               6.078e-15  1.126e-14  5.400e-01  0.58954    
## Home_TeamMÁLAGA               -3.625e-14  1.196e-14 -3.032e+00  0.00246 ** 
## Home_TeamMALLORCA              5.773e-15  1.861e-14  3.100e-01  0.75649    
## Home_TeamOSASUNA               2.648e-15  1.451e-14  1.820e-01  0.85521    
## Home_TeamRAYO VALLECANO        5.360e-15  1.315e-14  4.080e-01  0.68365    
## Home_TeamREAL BETIS            3.260e-15  1.165e-14  2.800e-01  0.77955    
## Home_TeamREAL MADRID           4.905e-15  1.219e-14  4.020e-01  0.68743    
## Home_TeamREAL SOCIEDAD         1.815e-15  1.112e-14  1.630e-01  0.87036    
## Home_TeamSEVILLA FC            3.926e-15  1.129e-14  3.480e-01  0.72803    
## Home_TeamVALENCIA              9.348e-16  1.108e-14  8.400e-02  0.93276    
## Home_TeamVALLADOLID           -4.173e-15  1.452e-14 -2.870e-01  0.77384    
## Home_TeamVILLARREAL            4.499e-15  1.109e-14  4.060e-01  0.68500    
## Away_TeamALMERÍA               1.049e-14  1.885e-14  5.560e-01  0.57813    
## Away_TeamATHLETIC             -2.360e-14  1.092e-14 -2.162e+00  0.03074 *  
## Away_TeamATLETICO MADRID       1.437e-15  1.104e-14  1.300e-01  0.89649    
## Away_TeamBARCELONA             9.250e-15  1.288e-14  7.180e-01  0.47269    
## Away_TeamCELTA                 1.482e-14  1.109e-14  1.336e+00  0.18158    
## Away_TeamCÓRDOBA               3.929e-15  1.886e-14  2.080e-01  0.83506    
## Away_TeamDEPORTIVO             8.113e-15  1.202e-14  6.750e-01  0.49973    
## Away_TeamEIBAR                 3.268e-15  1.102e-14  2.970e-01  0.76687    
## Away_TeamELCHE                 1.217e-14  1.886e-14  6.450e-01  0.51880    
## Away_TeamESPANYOL              2.738e-15  1.079e-14  2.540e-01  0.79967    
## Away_TeamGETAFE                2.524e-15  1.134e-14  2.230e-01  0.82393    
## Away_TeamGIJÓN                 8.525e-16  1.454e-14  5.900e-02  0.95326    
## Away_TeamGIRONA                4.338e-15  1.441e-14  3.010e-01  0.76338    
## Away_TeamGRANADA               2.116e-15  1.184e-14  1.790e-01  0.85820    
## Away_TeamHUESCA               -7.336e-15  1.845e-14 -3.980e-01  0.69096    
## Away_TeamLAS PALMAS            7.845e-15  1.330e-14  5.900e-01  0.55530    
## Away_TeamLEGANÉS              -1.421e-15  1.173e-14 -1.210e-01  0.90359    
## Away_TeamLEVANTE               2.940e-15  1.119e-14  2.630e-01  0.79276    
## Away_TeamMÁLAGA                3.987e-15  1.197e-14  3.330e-01  0.73909    
## Away_TeamMALLORCA             -1.262e-15  1.859e-14 -6.800e-02  0.94587    
## Away_TeamOSASUNA              -4.229e-16  1.438e-14 -2.900e-02  0.97654    
## Away_TeamRAYO VALLECANO        9.250e-15  1.317e-14  7.030e-01  0.48236    
## Away_TeamREAL BETIS            1.141e-14  1.163e-14  9.810e-01  0.32673    
## Away_TeamREAL MADRID           2.422e-16  1.201e-14  2.000e-02  0.98391    
## Away_TeamREAL SOCIEDAD         2.158e-15  1.108e-14  1.950e-01  0.84559    
## Away_TeamSEVILLA FC            4.373e-15  1.109e-14  3.940e-01  0.69329    
## Away_TeamVALENCIA              3.403e-15  1.102e-14  3.090e-01  0.75740    
## Away_TeamVALLADOLID            4.521e-15  1.442e-14  3.140e-01  0.75391    
## Away_TeamVILLARREAL            2.991e-15  1.101e-14  2.720e-01  0.78586    
## `Home_Team_Possession_%`      -6.413e-16  5.592e-16 -1.147e+00  0.25159    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -1.440e-15  8.454e-15 -1.700e-01  0.86474    
## Home_Team_On_Target_Shots     -1.418e-15  8.455e-15 -1.680e-01  0.86683    
## Home_Team_Total_Shots          2.014e-15  8.419e-15  2.390e-01  0.81092    
## Home_Team_Blocked_Shots       -2.676e-15  8.430e-15 -3.170e-01  0.75092    
## Home_Team_Corners              1.000e+00  6.952e-16  1.439e+15  < 2e-16 ***
## Home_Team_Throw_Ins            4.072e-16  3.039e-16  1.340e+00  0.18040    
## `Home_Team_Pass_Success_%`     1.103e-15  5.956e-16  1.853e+00  0.06405 .  
## Home_Team_Aerials_Won          5.643e-17  3.163e-16  1.780e-01  0.85845    
## Home_Team_Clearances           6.460e-16  2.695e-16  2.397e+00  0.01659 *  
## Home_Team_Fouls                3.775e-16  4.428e-16  8.530e-01  0.39402    
## Home_Team_Yellow_Cards        -4.951e-16  1.136e-15 -4.360e-01  0.66312    
## Home_Team_Second_Yellow_Cards -9.614e-17  6.484e-15 -1.500e-02  0.98817    
## Home_Team_Red_Cards           -6.173e-14  7.032e-15 -8.777e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots     1.508e-15  7.260e-15  2.080e-01  0.83547    
## Away_Team_On_Target_Shots      7.650e-16  7.291e-15  1.050e-01  0.91644    
## Away_Team_Total_Shots         -8.852e-16  7.236e-15 -1.220e-01  0.90264    
## Away_Team_Blocked_Shots        1.946e-15  7.293e-15  2.670e-01  0.78963    
## Away_Team_Corners              1.000e+00  7.607e-16  1.315e+15  < 2e-16 ***
## Away_Team_Throw_Ins            2.144e-16  3.248e-16  6.600e-01  0.50925    
## `Away_Team_Pass_Success_%`    -6.097e-16  5.548e-16 -1.099e+00  0.27188    
## Away_Team_Aerials_Won         -8.847e-17  3.125e-16 -2.830e-01  0.77715    
## Away_Team_Clearances           1.831e-16  2.480e-16  7.380e-01  0.46055    
## Away_Team_Fouls                6.692e-16  4.378e-16  1.528e+00  0.12655    
## Away_Team_Yellow_Cards        -3.324e-16  1.155e-15 -2.880e-01  0.77359    
## Away_Team_Second_Yellow_Cards  5.051e-16  5.595e-15  9.000e-02  0.92807    
## Away_Team_Red_Cards            6.042e-15  6.889e-15  8.770e-01  0.38057    
## Home_Team_Goals_Scored         1.400e-15  1.989e-15  7.040e-01  0.48168    
## Away_Team_Goals_Scored         1.466e-15  2.248e-15  6.520e-01  0.51418    
## year                          -4.720e-13  2.046e-13 -2.307e+00  0.02113 *  
## scorex                         7.419e-15  4.994e-15  1.486e+00  0.13754    
## score2                         1.084e-14  7.089e-15  1.529e+00  0.12639    
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -1.220e-14  5.384e-15 -2.267e+00  0.02351 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 7.136e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 5.553e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_centros <- lm(total_throw_ins~., data = train)
summary(lm_centros)
## 
## Call:
## lm(formula = total_throw_ins ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -4.561e-12 -1.320e-14 -2.500e-15  8.600e-15  6.560e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.279e-09  5.956e-10  2.148e+00 0.031834 *  
## ...1                           1.683e-15  7.781e-16  2.163e+00 0.030613 *  
## Home_TeamALMERÍA               8.982e-15  2.727e-14  3.290e-01 0.741949    
## Home_TeamATHLETIC              9.438e-15  1.577e-14  5.990e-01 0.549515    
## Home_TeamATLETICO MADRID       2.146e-15  1.595e-14  1.350e-01 0.893004    
## Home_TeamBARCELONA             3.341e-14  1.854e-14  1.802e+00 0.071659 .  
## Home_TeamCELTA                 1.445e-14  1.624e-14  8.900e-01 0.373674    
## Home_TeamCÓRDOBA               2.248e-14  2.729e-14  8.240e-01 0.410206    
## Home_TeamDEPORTIVO             2.687e-15  1.732e-14  1.550e-01 0.876724    
## Home_TeamEIBAR                 5.974e-15  1.608e-14  3.720e-01 0.710198    
## Home_TeamELCHE                 1.171e-14  2.736e-14  4.280e-01 0.668734    
## Home_TeamESPANYOL             -1.293e-15  1.561e-14 -8.300e-02 0.933969    
## Home_TeamGETAFE               -5.727e-15  1.643e-14 -3.490e-01 0.727463    
## Home_TeamGIJÓN                 1.327e-14  2.121e-14  6.260e-01 0.531656    
## Home_TeamGIRONA               -2.835e-15  2.086e-14 -1.360e-01 0.891882    
## Home_TeamGRANADA              -1.696e-14  1.712e-14 -9.910e-01 0.321934    
## Home_TeamHUESCA               -2.742e-15  2.681e-14 -1.020e-01 0.918554    
## Home_TeamLAS PALMAS            3.309e-15  1.954e-14  1.690e-01 0.865528    
## Home_TeamLEGANÉS               1.003e-14  1.696e-14  5.910e-01 0.554605    
## Home_TeamLEVANTE               9.695e-15  1.628e-14  5.950e-01 0.551632    
## Home_TeamMÁLAGA               -5.999e-14  1.728e-14 -3.471e+00 0.000529 ***
## Home_TeamMALLORCA             -9.780e-15  2.691e-14 -3.630e-01 0.716291    
## Home_TeamOSASUNA              -2.108e-14  2.097e-14 -1.005e+00 0.315058    
## Home_TeamRAYO VALLECANO        1.802e-14  1.901e-14  9.480e-01 0.343302    
## Home_TeamREAL BETIS            3.281e-15  1.683e-14  1.950e-01 0.845468    
## Home_TeamREAL MADRID           1.358e-14  1.762e-14  7.710e-01 0.440945    
## Home_TeamREAL SOCIEDAD         2.423e-15  1.608e-14  1.510e-01 0.880186    
## Home_TeamSEVILLA FC           -2.065e-15  1.632e-14 -1.270e-01 0.899333    
## Home_TeamVALENCIA              4.557e-15  1.602e-14  2.850e-01 0.776040    
## Home_TeamVALLADOLID           -1.345e-15  2.099e-14 -6.400e-02 0.948904    
## Home_TeamVILLARREAL            4.258e-16  1.603e-14  2.700e-02 0.978814    
## Away_TeamALMERÍA               1.862e-14  2.726e-14  6.830e-01 0.494639    
## Away_TeamATHLETIC             -3.856e-14  1.578e-14 -2.443e+00 0.014631 *  
## Away_TeamATLETICO MADRID       5.965e-15  1.596e-14  3.740e-01 0.708710    
## Away_TeamBARCELONA             1.505e-14  1.862e-14  8.080e-01 0.418978    
## Away_TeamCELTA                 3.889e-15  1.604e-14  2.420e-01 0.808426    
## Away_TeamCÓRDOBA               5.232e-16  2.727e-14  1.900e-02 0.984694    
## Away_TeamDEPORTIVO            -7.569e-16  1.737e-14 -4.400e-02 0.965254    
## Away_TeamEIBAR                 1.049e-14  1.593e-14  6.580e-01 0.510297    
## Away_TeamELCHE                 5.249e-15  2.726e-14  1.930e-01 0.847349    
## Away_TeamESPANYOL             -6.853e-15  1.560e-14 -4.390e-01 0.660373    
## Away_TeamGETAFE               -1.629e-15  1.640e-14 -9.900e-02 0.920886    
## Away_TeamGIJÓN                -1.627e-14  2.102e-14 -7.740e-01 0.438976    
## Away_TeamGIRONA                2.354e-15  2.083e-14  1.130e-01 0.910012    
## Away_TeamGRANADA               1.501e-14  1.711e-14  8.770e-01 0.380618    
## Away_TeamHUESCA               -1.746e-14  2.667e-14 -6.550e-01 0.512827    
## Away_TeamLAS PALMAS            5.988e-15  1.922e-14  3.120e-01 0.755447    
## Away_TeamLEGANÉS              -4.083e-15  1.696e-14 -2.410e-01 0.809794    
## Away_TeamLEVANTE              -3.903e-15  1.618e-14 -2.410e-01 0.809368    
## Away_TeamMÁLAGA               -8.357e-15  1.730e-14 -4.830e-01 0.629207    
## Away_TeamMALLORCA             -1.423e-14  2.688e-14 -5.290e-01 0.596595    
## Away_TeamOSASUNA              -7.924e-15  2.079e-14 -3.810e-01 0.703136    
## Away_TeamRAYO VALLECANO        1.511e-15  1.903e-14  7.900e-02 0.936720    
## Away_TeamREAL BETIS            3.906e-15  1.681e-14  2.320e-01 0.816304    
## Away_TeamREAL MADRID          -1.719e-15  1.736e-14 -9.900e-02 0.921138    
## Away_TeamREAL SOCIEDAD        -1.146e-14  1.602e-14 -7.150e-01 0.474391    
## Away_TeamSEVILLA FC           -8.318e-15  1.602e-14 -5.190e-01 0.603735    
## Away_TeamVALENCIA             -1.018e-15  1.592e-14 -6.400e-02 0.949042    
## Away_TeamVALLADOLID           -5.975e-15  2.085e-14 -2.870e-01 0.774433    
## Away_TeamVILLARREAL           -9.953e-15  1.591e-14 -6.260e-01 0.531667    
## `Home_Team_Possession_%`      -1.568e-15  8.083e-16 -1.940e+00 0.052567 .  
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     5.660e-16  1.222e-14  4.600e-02 0.963061    
## Home_Team_On_Target_Shots      2.278e-15  1.222e-14  1.860e-01 0.852185    
## Home_Team_Total_Shots          7.931e-17  1.217e-14  7.000e-03 0.994801    
## Home_Team_Blocked_Shots       -1.246e-15  1.219e-14 -1.020e-01 0.918603    
## Home_Team_Corners             -4.752e-16  1.005e-15 -4.730e-01 0.636339    
## Home_Team_Throw_Ins            1.000e+00  4.392e-16  2.277e+15  < 2e-16 ***
## `Home_Team_Pass_Success_%`     2.516e-15  8.609e-16  2.923e+00 0.003506 ** 
## Home_Team_Aerials_Won          4.588e-17  4.573e-16  1.000e-01 0.920087    
## Home_Team_Clearances          -1.845e-16  3.895e-16 -4.740e-01 0.635808    
## Home_Team_Fouls                1.052e-15  6.400e-16  1.643e+00 0.100524    
## Home_Team_Yellow_Cards        -2.302e-16  1.643e-15 -1.400e-01 0.888567    
## Home_Team_Second_Yellow_Cards  1.835e-15  9.372e-15  1.960e-01 0.844780    
## Home_Team_Red_Cards           -8.440e-14  1.017e-14 -8.303e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots     2.376e-15  1.049e-14  2.260e-01 0.820881    
## Away_Team_On_Target_Shots     -4.387e-16  1.054e-14 -4.200e-02 0.966799    
## Away_Team_Total_Shots         -6.522e-16  1.046e-14 -6.200e-02 0.950288    
## Away_Team_Blocked_Shots        1.204e-15  1.054e-14  1.140e-01 0.909067    
## Away_Team_Corners              1.681e-15  1.100e-15  1.529e+00 0.126525    
## Away_Team_Throw_Ins            1.000e+00  4.696e-16  2.130e+15  < 2e-16 ***
## `Away_Team_Pass_Success_%`    -6.680e-16  8.020e-16 -8.330e-01 0.405003    
## Away_Team_Aerials_Won         -1.403e-16  4.518e-16 -3.110e-01 0.756199    
## Away_Team_Clearances           3.342e-16  3.585e-16  9.320e-01 0.351382    
## Away_Team_Fouls                9.319e-16  6.329e-16  1.472e+00 0.141063    
## Away_Team_Yellow_Cards        -6.374e-16  1.670e-15 -3.820e-01 0.702764    
## Away_Team_Second_Yellow_Cards  3.181e-15  8.087e-15  3.930e-01 0.694108    
## Away_Team_Red_Cards            1.157e-14  9.958e-15  1.161e+00 0.245595    
## Home_Team_Goals_Scored         2.836e-15  2.875e-15  9.860e-01 0.324029    
## Away_Team_Goals_Scored         1.630e-15  3.249e-15  5.020e-01 0.615961    
## year                          -6.354e-13  2.957e-13 -2.148e+00 0.031785 *  
## scorex                         1.171e-14  7.219e-15  1.622e+00 0.104898    
## score2                         1.861e-14  1.025e-14  1.816e+00 0.069551 .  
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -1.638e-14  7.783e-15 -2.104e+00 0.035454 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.032e-13 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.616e+29 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_d_aereos <- lm(total_aerials_won~., data = train)
summary(lm_d_aereos)
## 
## Call:
## lm(formula = total_aerials_won ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -1.409e-12 -6.110e-15 -6.600e-16  5.370e-15  6.267e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.964e-10  2.266e-10  8.670e-01 0.386164    
## ...1                           2.661e-16  2.961e-16  8.990e-01 0.368910    
## Home_TeamALMERÍA               4.345e-15  1.038e-14  4.190e-01 0.675488    
## Home_TeamATHLETIC              2.631e-14  6.000e-15  4.386e+00 1.21e-05 ***
## Home_TeamATLETICO MADRID       1.676e-14  6.071e-15  2.761e+00 0.005812 ** 
## Home_TeamBARCELONA            -2.925e-14  7.055e-15 -4.146e+00 3.51e-05 ***
## Home_TeamCELTA                 1.686e-14  6.180e-15  2.727e+00 0.006435 ** 
## Home_TeamCÓRDOBA               2.973e-14  1.039e-14  2.862e+00 0.004251 ** 
## Home_TeamDEPORTIVO             1.695e-14  6.591e-15  2.571e+00 0.010196 *  
## Home_TeamEIBAR                -9.792e-15  6.117e-15 -1.601e+00 0.109595    
## Home_TeamELCHE                 1.849e-14  1.041e-14  1.776e+00 0.075824 .  
## Home_TeamESPANYOL              2.433e-14  5.939e-15  4.096e+00 4.36e-05 ***
## Home_TeamGETAFE                2.789e-15  6.253e-15  4.460e-01 0.655656    
## Home_TeamGIJÓN                 2.944e-15  8.071e-15  3.650e-01 0.715323    
## Home_TeamGIRONA                4.519e-15  7.936e-15  5.690e-01 0.569145    
## Home_TeamGRANADA               8.437e-15  6.515e-15  1.295e+00 0.195435    
## Home_TeamHUESCA                1.931e-14  1.020e-14  1.893e+00 0.058449 .  
## Home_TeamLAS PALMAS            2.714e-14  7.434e-15  3.650e+00 0.000268 ***
## Home_TeamLEGANÉS               1.616e-14  6.456e-15  2.503e+00 0.012378 *  
## Home_TeamLEVANTE               7.478e-15  6.196e-15  1.207e+00 0.227626    
## Home_TeamMÁLAGA               -3.570e-15  6.577e-15 -5.430e-01 0.587304    
## Home_TeamMALLORCA              2.996e-14  1.024e-14  2.926e+00 0.003470 ** 
## Home_TeamOSASUNA              -2.142e-14  7.981e-15 -2.684e+00 0.007322 ** 
## Home_TeamRAYO VALLECANO        1.318e-14  7.234e-15  1.822e+00 0.068565 .  
## Home_TeamREAL BETIS            7.066e-15  6.406e-15  1.103e+00 0.270145    
## Home_TeamREAL MADRID           2.102e-14  6.706e-15  3.135e+00 0.001744 ** 
## Home_TeamREAL SOCIEDAD         1.722e-14  6.117e-15  2.814e+00 0.004933 ** 
## Home_TeamSEVILLA FC            1.184e-14  6.210e-15  1.906e+00 0.056764 .  
## Home_TeamVALENCIA              1.186e-14  6.094e-15  1.947e+00 0.051715 .  
## Home_TeamVALLADOLID            1.209e-14  7.987e-15  1.514e+00 0.130292    
## Home_TeamVILLARREAL            2.666e-14  6.101e-15  4.370e+00 1.30e-05 ***
## Away_TeamALMERÍA               8.576e-15  1.037e-14  8.270e-01 0.408383    
## Away_TeamATHLETIC              2.122e-15  6.005e-15  3.530e-01 0.723882    
## Away_TeamATLETICO MADRID       2.196e-14  6.075e-15  3.615e+00 0.000308 ***
## Away_TeamBARCELONA            -6.251e-14  7.084e-15 -8.824e+00  < 2e-16 ***
## Away_TeamCELTA                 9.182e-15  6.102e-15  1.505e+00 0.132539    
## Away_TeamCÓRDOBA               1.043e-14  1.038e-14  1.005e+00 0.315128    
## Away_TeamDEPORTIVO             1.003e-14  6.611e-15  1.517e+00 0.129299    
## Away_TeamEIBAR                 2.040e-14  6.063e-15  3.364e+00 0.000781 ***
## Away_TeamELCHE                 1.337e-14  1.037e-14  1.289e+00 0.197686    
## Away_TeamESPANYOL              2.366e-16  5.934e-15  4.000e-02 0.968205    
## Away_TeamGETAFE               -1.128e-14  6.240e-15 -1.808e+00 0.070712 .  
## Away_TeamGIJÓN                -3.893e-15  8.000e-15 -4.870e-01 0.626537    
## Away_TeamGIRONA                1.645e-14  7.926e-15  2.075e+00 0.038097 *  
## Away_TeamGRANADA               3.232e-15  6.513e-15  4.960e-01 0.619789    
## Away_TeamHUESCA               -8.399e-15  1.015e-14 -8.280e-01 0.408002    
## Away_TeamLAS PALMAS            2.448e-14  7.315e-15  3.346e+00 0.000834 ***
## Away_TeamLEGANÉS              -5.181e-17  6.454e-15 -8.000e-03 0.993596    
## Away_TeamLEVANTE               3.237e-15  6.156e-15  5.260e-01 0.599098    
## Away_TeamMÁLAGA                5.105e-15  6.585e-15  7.750e-01 0.438267    
## Away_TeamMALLORCA              1.801e-14  1.023e-14  1.761e+00 0.078394 .  
## Away_TeamOSASUNA              -1.724e-15  7.911e-15 -2.180e-01 0.827489    
## Away_TeamRAYO VALLECANO       -1.662e-14  7.242e-15 -2.295e+00 0.021811 *  
## Away_TeamREAL BETIS            4.912e-15  6.397e-15  7.680e-01 0.442688    
## Away_TeamREAL MADRID           1.544e-14  6.605e-15  2.338e+00 0.019483 *  
## Away_TeamREAL SOCIEDAD         3.695e-15  6.096e-15  6.060e-01 0.544483    
## Away_TeamSEVILLA FC            8.350e-15  6.098e-15  1.369e+00 0.171048    
## Away_TeamVALENCIA              5.095e-15  6.060e-15  8.410e-01 0.400528    
## Away_TeamVALLADOLID            7.520e-15  7.933e-15  9.480e-01 0.343224    
## Away_TeamVILLARREAL            3.972e-15  6.055e-15  6.560e-01 0.511879    
## `Home_Team_Possession_%`       4.632e-16  3.076e-16  1.506e+00 0.132261    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     1.935e-15  4.650e-15  4.160e-01 0.677327    
## Home_Team_On_Target_Shots      3.656e-16  4.651e-15  7.900e-02 0.937355    
## Home_Team_Total_Shots         -1.289e-15  4.631e-15 -2.780e-01 0.780741    
## Home_Team_Blocked_Shots        1.097e-15  4.637e-15  2.370e-01 0.813007    
## Home_Team_Corners              1.692e-16  3.824e-16  4.420e-01 0.658200    
## Home_Team_Throw_Ins           -2.690e-16  1.671e-16 -1.610e+00 0.107647    
## `Home_Team_Pass_Success_%`    -1.888e-15  3.276e-16 -5.761e+00 9.52e-09 ***
## Home_Team_Aerials_Won          1.000e+00  1.740e-16  5.747e+15  < 2e-16 ***
## Home_Team_Clearances           2.143e-16  1.482e-16  1.446e+00 0.148368    
## Home_Team_Fouls                3.788e-16  2.436e-16  1.555e+00 0.120037    
## Home_Team_Yellow_Cards        -3.871e-17  6.251e-16 -6.200e-02 0.950620    
## Home_Team_Second_Yellow_Cards  3.306e-15  3.566e-15  9.270e-01 0.354000    
## Home_Team_Red_Cards           -2.979e-14  3.868e-15 -7.701e+00 2.04e-14 ***
## Away_Team_Off_Target_Shots    -1.096e-15  3.994e-15 -2.740e-01 0.783827    
## Away_Team_On_Target_Shots     -1.942e-15  4.010e-15 -4.840e-01 0.628343    
## Away_Team_Total_Shots          1.630e-15  3.980e-15  4.090e-01 0.682291    
## Away_Team_Blocked_Shots       -1.912e-15  4.012e-15 -4.760e-01 0.633784    
## Away_Team_Corners             -2.189e-16  4.185e-16 -5.230e-01 0.600876    
## Away_Team_Throw_Ins           -1.553e-16  1.787e-16 -8.690e-01 0.384972    
## `Away_Team_Pass_Success_%`    -1.052e-15  3.052e-16 -3.446e+00 0.000580 ***
## Away_Team_Aerials_Won          1.000e+00  1.719e-16  5.817e+15  < 2e-16 ***
## Away_Team_Clearances           7.167e-18  1.364e-16  5.300e-02 0.958110    
## Away_Team_Fouls                3.612e-16  2.408e-16  1.500e+00 0.133843    
## Away_Team_Yellow_Cards         3.082e-16  6.356e-16  4.850e-01 0.627847    
## Away_Team_Second_Yellow_Cards -2.030e-15  3.077e-15 -6.600e-01 0.509526    
## Away_Team_Red_Cards            1.201e-15  3.789e-15  3.170e-01 0.751246    
## Home_Team_Goals_Scored         1.478e-15  1.094e-15  1.350e+00 0.177010    
## Away_Team_Goals_Scored         3.674e-16  1.236e-15  2.970e-01 0.766345    
## year                          -9.746e-14  1.125e-13 -8.660e-01 0.386574    
## scorex                         5.450e-15  2.747e-15  1.984e+00 0.047417 *  
## score2                         8.638e-15  3.899e-15  2.215e+00 0.026848 *  
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -2.441e-15  2.962e-15 -8.240e-01 0.409861    
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 3.925e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.847e+30 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_despejes <- lm(total_clearances~., data = train)
summary(lm_despejes)
## 
## Call:
## lm(formula = total_clearances ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -1.384e-12 -6.370e-15 -4.700e-16  6.720e-15  3.155e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    2.451e-10  2.380e-10  1.030e+00 0.303274    
## ...1                           3.139e-16  3.109e-16  1.009e+00 0.312853    
## Home_TeamALMERÍA               3.201e-14  1.090e-14  2.937e+00 0.003349 ** 
## Home_TeamATHLETIC              4.102e-14  6.300e-15  6.510e+00 9.29e-11 ***
## Home_TeamATLETICO MADRID       2.567e-14  6.376e-15  4.027e+00 5.85e-05 ***
## Home_TeamBARCELONA             1.654e-14  7.408e-15  2.233e+00 0.025672 *  
## Home_TeamCELTA                 2.956e-14  6.490e-15  4.556e+00 5.51e-06 ***
## Home_TeamCÓRDOBA               2.082e-14  1.091e-14  1.909e+00 0.056414 .  
## Home_TeamDEPORTIVO             2.790e-14  6.921e-15  4.031e+00 5.73e-05 ***
## Home_TeamEIBAR                 3.734e-14  6.424e-15  5.812e+00 7.07e-09 ***
## Home_TeamELCHE                 1.135e-14  1.093e-14  1.038e+00 0.299429    
## Home_TeamESPANYOL              1.398e-14  6.237e-15  2.242e+00 0.025047 *  
## Home_TeamGETAFE                6.179e-15  6.566e-15  9.410e-01 0.346799    
## Home_TeamGIJÓN                 2.463e-14  8.475e-15  2.906e+00 0.003701 ** 
## Home_TeamGIRONA                2.812e-14  8.334e-15  3.374e+00 0.000754 ***
## Home_TeamGRANADA               1.265e-14  6.841e-15  1.849e+00 0.064597 .  
## Home_TeamHUESCA                3.474e-14  1.071e-14  3.242e+00 0.001203 ** 
## Home_TeamLAS PALMAS            3.224e-14  7.807e-15  4.130e+00 3.76e-05 ***
## Home_TeamLEGANÉS               2.053e-14  6.779e-15  3.028e+00 0.002493 ** 
## Home_TeamLEVANTE               2.802e-14  6.507e-15  4.306e+00 1.74e-05 ***
## Home_TeamMÁLAGA                8.625e-15  6.907e-15  1.249e+00 0.211885    
## Home_TeamMALLORCA              1.020e-14  1.075e-14  9.490e-01 0.342750    
## Home_TeamOSASUNA               2.575e-14  8.381e-15  3.072e+00 0.002153 ** 
## Home_TeamRAYO VALLECANO        2.180e-14  7.597e-15  2.869e+00 0.004153 ** 
## Home_TeamREAL BETIS            2.531e-14  6.727e-15  3.763e+00 0.000173 ***
## Home_TeamREAL MADRID           3.311e-14  7.042e-15  4.703e+00 2.73e-06 ***
## Home_TeamREAL SOCIEDAD         3.010e-14  6.424e-15  4.685e+00 2.97e-06 ***
## Home_TeamSEVILLA FC            4.758e-14  6.522e-15  7.295e+00 4.15e-13 ***
## Home_TeamVALENCIA              1.910e-14  6.400e-15  2.985e+00 0.002870 ** 
## Home_TeamVALLADOLID            1.335e-14  8.387e-15  1.592e+00 0.111610    
## Home_TeamVILLARREAL            1.935e-14  6.406e-15  3.020e+00 0.002557 ** 
## Away_TeamALMERÍA              -2.942e-14  1.089e-14 -2.701e+00 0.006958 ** 
## Away_TeamATHLETIC             -4.387e-14  6.306e-15 -6.956e+00 4.60e-12 ***
## Away_TeamATLETICO MADRID      -4.127e-14  6.379e-15 -6.469e+00 1.21e-10 ***
## Away_TeamBARCELONA            -3.339e-14  7.439e-15 -4.489e+00 7.53e-06 ***
## Away_TeamCELTA                -2.867e-14  6.408e-15 -4.474e+00 8.08e-06 ***
## Away_TeamCÓRDOBA               4.079e-15  1.090e-14  3.740e-01 0.708180    
## Away_TeamDEPORTIVO            -2.138e-14  6.942e-15 -3.080e+00 0.002094 ** 
## Away_TeamEIBAR                -3.296e-14  6.367e-15 -5.177e+00 2.47e-07 ***
## Away_TeamELCHE                -2.126e-14  1.089e-14 -1.951e+00 0.051152 .  
## Away_TeamESPANYOL             -1.810e-14  6.232e-15 -2.905e+00 0.003709 ** 
## Away_TeamGETAFE               -1.719e-14  6.553e-15 -2.623e+00 0.008787 ** 
## Away_TeamGIJÓN                -7.920e-15  8.400e-15 -9.430e-01 0.345900    
## Away_TeamGIRONA               -1.502e-14  8.323e-15 -1.805e+00 0.071234 .  
## Away_TeamGRANADA              -1.483e-14  6.839e-15 -2.168e+00 0.030290 *  
## Away_TeamHUESCA               -3.403e-15  1.066e-14 -3.190e-01 0.749555    
## Away_TeamLAS PALMAS           -4.276e-14  7.682e-15 -5.567e+00 2.91e-08 ***
## Away_TeamLEGANÉS              -2.122e-14  6.778e-15 -3.131e+00 0.001764 ** 
## Away_TeamLEVANTE              -1.499e-14  6.464e-15 -2.319e+00 0.020486 *  
## Away_TeamMÁLAGA               -2.776e-14  6.915e-15 -4.015e+00 6.16e-05 ***
## Away_TeamMALLORCA             -2.882e-14  1.074e-14 -2.683e+00 0.007354 ** 
## Away_TeamOSASUNA              -6.623e-15  8.308e-15 -7.970e-01 0.425434    
## Away_TeamRAYO VALLECANO       -2.297e-14  7.605e-15 -3.021e+00 0.002550 ** 
## Away_TeamREAL BETIS           -2.025e-14  6.718e-15 -3.014e+00 0.002608 ** 
## Away_TeamREAL MADRID          -6.095e-14  6.936e-15 -8.787e+00  < 2e-16 ***
## Away_TeamREAL SOCIEDAD        -2.286e-14  6.401e-15 -3.571e+00 0.000363 ***
## Away_TeamSEVILLA FC           -2.705e-14  6.403e-15 -4.225e+00 2.49e-05 ***
## Away_TeamVALENCIA             -8.078e-15  6.364e-15 -1.269e+00 0.204402    
## Away_TeamVALLADOLID           -3.326e-15  8.330e-15 -3.990e-01 0.689731    
## Away_TeamVILLARREAL           -9.608e-15  6.358e-15 -1.511e+00 0.130904    
## `Home_Team_Possession_%`      -9.239e-16  3.230e-16 -2.860e+00 0.004271 ** 
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     4.263e-16  4.883e-15  8.700e-02 0.930446    
## Home_Team_On_Target_Shots      1.082e-15  4.884e-15  2.220e-01 0.824636    
## Home_Team_Total_Shots         -3.808e-17  4.863e-15 -8.000e-03 0.993752    
## Home_Team_Blocked_Shots        8.539e-16  4.870e-15  1.750e-01 0.860819    
## Home_Team_Corners             -9.671e-16  4.016e-16 -2.408e+00 0.016108 *  
## Home_Team_Throw_Ins            1.130e-15  1.755e-16  6.439e+00 1.48e-10 ***
## `Home_Team_Pass_Success_%`    -3.685e-17  3.440e-16 -1.070e-01 0.914715    
## Home_Team_Aerials_Won          5.874e-17  1.827e-16  3.210e-01 0.747889    
## Home_Team_Clearances           1.000e+00  1.556e-16  6.425e+15  < 2e-16 ***
## Home_Team_Fouls                2.125e-16  2.558e-16  8.310e-01 0.406140    
## Home_Team_Yellow_Cards         7.219e-16  6.564e-16  1.100e+00 0.271556    
## Home_Team_Second_Yellow_Cards  1.355e-15  3.745e-15  3.620e-01 0.717628    
## Home_Team_Red_Cards           -2.667e-14  4.062e-15 -6.565e+00 6.48e-11 ***
## Away_Team_Off_Target_Shots     4.238e-15  4.194e-15  1.011e+00 0.312341    
## Away_Team_On_Target_Shots      3.139e-15  4.211e-15  7.450e-01 0.456087    
## Away_Team_Total_Shots         -3.236e-15  4.180e-15 -7.740e-01 0.438864    
## Away_Team_Blocked_Shots        3.412e-15  4.213e-15  8.100e-01 0.418137    
## Away_Team_Corners             -4.319e-16  4.394e-16 -9.830e-01 0.325806    
## Away_Team_Throw_Ins            2.197e-17  1.876e-16  1.170e-01 0.906789    
## `Away_Team_Pass_Success_%`     2.711e-16  3.205e-16  8.460e-01 0.397639    
## Away_Team_Aerials_Won          1.230e-16  1.805e-16  6.820e-01 0.495582    
## Away_Team_Clearances           1.000e+00  1.433e-16  6.980e+15  < 2e-16 ***
## Away_Team_Fouls                1.961e-16  2.529e-16  7.750e-01 0.438175    
## Away_Team_Yellow_Cards         1.458e-16  6.674e-16  2.180e-01 0.827112    
## Away_Team_Second_Yellow_Cards  3.318e-16  3.232e-15  1.030e-01 0.918225    
## Away_Team_Red_Cards            8.245e-15  3.979e-15  2.072e+00 0.038387 *  
## Home_Team_Goals_Scored        -6.771e-17  1.149e-15 -5.900e-02 0.953017    
## Away_Team_Goals_Scored         1.123e-15  1.298e-15  8.650e-01 0.387204    
## year                          -1.217e-13  1.182e-13 -1.030e+00 0.303166    
## scorex                         2.584e-16  2.885e-15  9.000e-02 0.928632    
## score2                         2.855e-15  4.095e-15  6.970e-01 0.485762    
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -2.994e-15  3.110e-15 -9.630e-01 0.335786    
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 4.122e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 1.858e+30 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_faltas <- lm(total_fouls~., data = train)
summary(lm_faltas)
## 
## Call:
## lm(formula = total_fouls ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -6.540e-13 -1.200e-14  6.000e-15  2.250e-14  7.834e-12 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                   -2.030e-09  1.006e-09 -2.018e+00  0.04374 *  
## ...1                          -2.666e-15  1.315e-15 -2.028e+00  0.04268 *  
## Home_TeamALMERÍA              -3.147e-14  4.608e-14 -6.830e-01  0.49466    
## Home_TeamATHLETIC             -1.332e-14  2.664e-14 -5.000e-01  0.61719    
## Home_TeamATLETICO MADRID      -1.377e-14  2.695e-14 -5.110e-01  0.60952    
## Home_TeamBARCELONA            -3.961e-14  3.132e-14 -1.265e+00  0.20614    
## Home_TeamCELTA                -2.154e-14  2.744e-14 -7.850e-01  0.43250    
## Home_TeamCÓRDOBA              -1.465e-14  4.611e-14 -3.180e-01  0.75071    
## Home_TeamDEPORTIVO            -1.459e-14  2.926e-14 -4.990e-01  0.61803    
## Home_TeamEIBAR                -1.863e-14  2.716e-14 -6.860e-01  0.49276    
## Home_TeamELCHE                -1.212e-14  4.622e-14 -2.620e-01  0.79320    
## Home_TeamESPANYOL             -4.794e-15  2.637e-14 -1.820e-01  0.85574    
## Home_TeamGETAFE               -2.246e-14  2.776e-14 -8.090e-01  0.41850    
## Home_TeamGIJÓN                -2.376e-14  3.583e-14 -6.630e-01  0.50736    
## Home_TeamGIRONA                5.732e-15  3.523e-14  1.630e-01  0.87079    
## Home_TeamGRANADA              -6.143e-15  2.892e-14 -2.120e-01  0.83181    
## Home_TeamHUESCA                3.974e-15  4.529e-14  8.800e-02  0.93008    
## Home_TeamLAS PALMAS           -1.534e-14  3.301e-14 -4.650e-01  0.64207    
## Home_TeamLEGANÉS              -1.316e-14  2.866e-14 -4.590e-01  0.64628    
## Home_TeamLEVANTE              -2.566e-14  2.751e-14 -9.330e-01  0.35105    
## Home_TeamMÁLAGA                8.515e-14  2.920e-14  2.916e+00  0.00358 ** 
## Home_TeamMALLORCA             -1.205e-14  4.546e-14 -2.650e-01  0.79101    
## Home_TeamOSASUNA              -1.714e-14  3.543e-14 -4.840e-01  0.62855    
## Home_TeamRAYO VALLECANO       -2.052e-14  3.212e-14 -6.390e-01  0.52296    
## Home_TeamREAL BETIS           -1.883e-14  2.844e-14 -6.620e-01  0.50804    
## Home_TeamREAL MADRID          -2.790e-14  2.977e-14 -9.370e-01  0.34884    
## Home_TeamREAL SOCIEDAD        -1.570e-14  2.716e-14 -5.780e-01  0.56320    
## Home_TeamSEVILLA FC           -9.330e-15  2.757e-14 -3.380e-01  0.73509    
## Home_TeamVALENCIA             -1.069e-14  2.706e-14 -3.950e-01  0.69269    
## Home_TeamVALLADOLID           -9.416e-15  3.546e-14 -2.660e-01  0.79062    
## Home_TeamVILLARREAL           -1.324e-14  2.708e-14 -4.890e-01  0.62508    
## Away_TeamALMERÍA               7.144e-15  4.605e-14  1.550e-01  0.87672    
## Away_TeamATHLETIC              6.895e-14  2.666e-14  2.586e+00  0.00976 ** 
## Away_TeamATLETICO MADRID      -8.674e-15  2.697e-14 -3.220e-01  0.74777    
## Away_TeamBARCELONA            -1.308e-14  3.145e-14 -4.160e-01  0.67745    
## Away_TeamCELTA                -4.419e-15  2.709e-14 -1.630e-01  0.87045    
## Away_TeamCÓRDOBA              -1.860e-14  4.607e-14 -4.040e-01  0.68653    
## Away_TeamDEPORTIVO            -8.812e-16  2.935e-14 -3.000e-02  0.97605    
## Away_TeamEIBAR                -1.320e-14  2.692e-14 -4.900e-01  0.62386    
## Away_TeamELCHE                -2.374e-14  4.606e-14 -5.150e-01  0.60632    
## Away_TeamESPANYOL             -3.244e-15  2.635e-14 -1.230e-01  0.90201    
## Away_TeamGETAFE               -8.175e-15  2.770e-14 -2.950e-01  0.76797    
## Away_TeamGIJÓN                 6.303e-15  3.552e-14  1.770e-01  0.85915    
## Away_TeamGIRONA               -5.516e-15  3.519e-14 -1.570e-01  0.87543    
## Away_TeamGRANADA              -1.026e-14  2.891e-14 -3.550e-01  0.72278    
## Away_TeamHUESCA                1.033e-15  4.506e-14  2.300e-02  0.98172    
## Away_TeamLAS PALMAS           -4.880e-15  3.248e-14 -1.500e-01  0.88056    
## Away_TeamLEGANÉS              -5.360e-15  2.865e-14 -1.870e-01  0.85162    
## Away_TeamLEVANTE              -9.317e-15  2.733e-14 -3.410e-01  0.73320    
## Away_TeamMÁLAGA               -7.351e-16  2.924e-14 -2.500e-02  0.97994    
## Away_TeamMALLORCA              9.031e-15  4.541e-14  1.990e-01  0.84236    
## Away_TeamOSASUNA              -2.775e-15  3.512e-14 -7.900e-02  0.93703    
## Away_TeamRAYO VALLECANO       -8.693e-15  3.215e-14 -2.700e-01  0.78691    
## Away_TeamREAL BETIS           -1.095e-14  2.840e-14 -3.860e-01  0.69977    
## Away_TeamREAL MADRID           9.321e-15  2.932e-14  3.180e-01  0.75061    
## Away_TeamREAL SOCIEDAD         1.415e-15  2.706e-14  5.200e-02  0.95831    
## Away_TeamSEVILLA FC           -3.217e-15  2.707e-14 -1.190e-01  0.90541    
## Away_TeamVALENCIA              1.320e-14  2.690e-14  4.910e-01  0.62379    
## Away_TeamVALLADOLID            7.821e-15  3.522e-14  2.220e-01  0.82429    
## Away_TeamVILLARREAL           -3.457e-15  2.688e-14 -1.290e-01  0.89767    
## `Home_Team_Possession_%`       1.887e-15  1.366e-15  1.382e+00  0.16719    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -1.500e-15  2.065e-14 -7.300e-02  0.94210    
## Home_Team_On_Target_Shots     -2.531e-15  2.065e-14 -1.230e-01  0.90246    
## Home_Team_Total_Shots          8.683e-16  2.056e-14  4.200e-02  0.96632    
## Home_Team_Blocked_Shots        1.490e-15  2.059e-14  7.200e-02  0.94229    
## Home_Team_Corners             -1.493e-16  1.698e-15 -8.800e-02  0.92994    
## Home_Team_Throw_Ins           -1.454e-15  7.421e-16 -1.960e+00  0.05014 .  
## `Home_Team_Pass_Success_%`    -3.372e-15  1.454e-15 -2.318e+00  0.02052 *  
## Home_Team_Aerials_Won         -9.033e-17  7.726e-16 -1.170e-01  0.90693    
## Home_Team_Clearances          -8.960e-16  6.581e-16 -1.362e+00  0.17347    
## Home_Team_Fouls                1.000e+00  1.081e-15  9.248e+14  < 2e-16 ***
## Home_Team_Yellow_Cards         1.551e-15  2.775e-15  5.590e-01  0.57628    
## Home_Team_Second_Yellow_Cards  1.594e-15  1.583e-14  1.010e-01  0.91980    
## Home_Team_Red_Cards            1.545e-13  1.717e-14  8.996e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots    -4.290e-15  1.773e-14 -2.420e-01  0.80885    
## Away_Team_On_Target_Shots     -3.038e-16  1.780e-14 -1.700e-02  0.98639    
## Away_Team_Total_Shots          3.031e-15  1.767e-14  1.720e-01  0.86384    
## Away_Team_Blocked_Shots       -4.008e-15  1.781e-14 -2.250e-01  0.82199    
## Away_Team_Corners             -6.562e-16  1.858e-15 -3.530e-01  0.72397    
## Away_Team_Throw_Ins           -4.620e-16  7.933e-16 -5.820e-01  0.56041    
## `Away_Team_Pass_Success_%`     1.370e-15  1.355e-15  1.011e+00  0.31219    
## Away_Team_Aerials_Won          1.273e-17  7.633e-16  1.700e-02  0.98669    
## Away_Team_Clearances          -4.490e-16  6.057e-16 -7.410e-01  0.45857    
## Away_Team_Fouls                1.000e+00  1.069e-15  9.352e+14  < 2e-16 ***
## Away_Team_Yellow_Cards         2.631e-16  2.822e-15  9.300e-02  0.92572    
## Away_Team_Second_Yellow_Cards -3.285e-15  1.366e-14 -2.400e-01  0.81002    
## Away_Team_Red_Cards           -1.634e-14  1.682e-14 -9.710e-01  0.33149    
## Home_Team_Goals_Scored        -4.073e-15  4.858e-15 -8.380e-01  0.40189    
## Away_Team_Goals_Scored        -3.635e-15  5.489e-15 -6.620e-01  0.50790    
## year                           1.008e-12  4.996e-13  2.018e+00  0.04369 *  
## scorex                        -2.001e-14  1.220e-14 -1.640e+00  0.10106    
## score2                        -3.153e-14  1.731e-14 -1.821e+00  0.06869 .  
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                        2.605e-14  1.315e-14  1.981e+00  0.04773 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.743e-13 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.84e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_amarillas <- lm(total_yellow_cards~., data = train)
summary(lm_amarillas)
## 
## Call:
## lm(formula = total_yellow_cards ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -3.378e-12 -9.500e-15 -2.300e-15  5.500e-15  1.379e-13 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    9.795e-10  4.328e-10  2.263e+00  0.02373 *  
## ...1                           1.286e-15  5.655e-16  2.275e+00  0.02301 *  
## Home_TeamALMERÍA               1.301e-15  1.982e-14  6.600e-02  0.94767    
## Home_TeamATHLETIC             -7.515e-16  1.146e-14 -6.600e-02  0.94771    
## Home_TeamATLETICO MADRID       3.251e-15  1.159e-14  2.800e-01  0.77919    
## Home_TeamBARCELONA             6.030e-15  1.347e-14  4.480e-01  0.65448    
## Home_TeamCELTA                 3.854e-15  1.180e-14  3.270e-01  0.74405    
## Home_TeamCÓRDOBA               7.879e-16  1.984e-14  4.000e-02  0.96832    
## Home_TeamDEPORTIVO             2.029e-15  1.259e-14  1.610e-01  0.87194    
## Home_TeamEIBAR                -1.122e-15  1.168e-14 -9.600e-02  0.92348    
## Home_TeamELCHE                 7.758e-15  1.988e-14  3.900e-01  0.69638    
## Home_TeamESPANYOL             -5.897e-17  1.134e-14 -5.000e-03  0.99585    
## Home_TeamGETAFE                3.458e-15  1.194e-14  2.900e-01  0.77214    
## Home_TeamGIJÓN                 9.729e-15  1.541e-14  6.310e-01  0.52800    
## Home_TeamGIRONA               -3.542e-15  1.516e-14 -2.340e-01  0.81523    
## Home_TeamGRANADA               1.389e-15  1.244e-14  1.120e-01  0.91110    
## Home_TeamHUESCA               -7.080e-15  1.948e-14 -3.630e-01  0.71636    
## Home_TeamLAS PALMAS            3.694e-16  1.420e-14  2.600e-02  0.97925    
## Home_TeamLEGANÉS               2.749e-15  1.233e-14  2.230e-01  0.82357    
## Home_TeamLEVANTE               4.085e-15  1.183e-14  3.450e-01  0.72999    
## Home_TeamMÁLAGA               -3.942e-14  1.256e-14 -3.138e+00  0.00172 ** 
## Home_TeamMALLORCA             -7.127e-16  1.955e-14 -3.600e-02  0.97093    
## Home_TeamOSASUNA              -1.124e-15  1.524e-14 -7.400e-02  0.94123    
## Home_TeamRAYO VALLECANO        3.938e-15  1.382e-14  2.850e-01  0.77563    
## Home_TeamREAL BETIS            4.570e-15  1.223e-14  3.740e-01  0.70877    
## Home_TeamREAL MADRID           1.229e-14  1.281e-14  9.600e-01  0.33722    
## Home_TeamREAL SOCIEDAD         4.884e-17  1.168e-14  4.000e-03  0.99666    
## Home_TeamSEVILLA FC            2.286e-15  1.186e-14  1.930e-01  0.84718    
## Home_TeamVALENCIA              4.268e-15  1.164e-14  3.670e-01  0.71389    
## Home_TeamVALLADOLID           -5.953e-15  1.525e-14 -3.900e-01  0.69637    
## Home_TeamVILLARREAL            4.532e-15  1.165e-14  3.890e-01  0.69733    
## Away_TeamALMERÍA              -3.538e-15  1.981e-14 -1.790e-01  0.85824    
## Away_TeamATHLETIC             -3.177e-14  1.147e-14 -2.771e+00  0.00564 ** 
## Away_TeamATLETICO MADRID      -8.686e-16  1.160e-14 -7.500e-02  0.94033    
## Away_TeamBARCELONA             1.005e-14  1.353e-14  7.420e-01  0.45787    
## Away_TeamCELTA                 4.682e-16  1.165e-14  4.000e-02  0.96796    
## Away_TeamCÓRDOBA               6.019e-15  1.982e-14  3.040e-01  0.76139    
## Away_TeamDEPORTIVO            -7.317e-16  1.263e-14 -5.800e-02  0.95379    
## Away_TeamEIBAR                -3.252e-15  1.158e-14 -2.810e-01  0.77884    
## Away_TeamELCHE                 1.286e-14  1.981e-14  6.490e-01  0.51622    
## Away_TeamESPANYOL              3.095e-15  1.133e-14  2.730e-01  0.78480    
## Away_TeamGETAFE               -2.544e-15  1.192e-14 -2.130e-01  0.83098    
## Away_TeamGIJÓN                -2.544e-15  1.528e-14 -1.670e-01  0.86774    
## Away_TeamGIRONA                2.754e-15  1.514e-14  1.820e-01  0.85565    
## Away_TeamGRANADA               2.812e-15  1.244e-14  2.260e-01  0.82118    
## Away_TeamHUESCA               -4.211e-15  1.938e-14 -2.170e-01  0.82801    
## Away_TeamLAS PALMAS            8.474e-15  1.397e-14  6.070e-01  0.54422    
## Away_TeamLEGANÉS              -1.698e-15  1.233e-14 -1.380e-01  0.89047    
## Away_TeamLEVANTE               6.854e-16  1.176e-14  5.800e-02  0.95351    
## Away_TeamMÁLAGA               -2.307e-16  1.258e-14 -1.800e-02  0.98537    
## Away_TeamMALLORCA              1.503e-15  1.953e-14  7.700e-02  0.93866    
## Away_TeamOSASUNA              -4.290e-15  1.511e-14 -2.840e-01  0.77647    
## Away_TeamRAYO VALLECANO        3.420e-15  1.383e-14  2.470e-01  0.80474    
## Away_TeamREAL BETIS            8.013e-15  1.222e-14  6.560e-01  0.51200    
## Away_TeamREAL MADRID           1.977e-15  1.261e-14  1.570e-01  0.87546    
## Away_TeamREAL SOCIEDAD        -1.587e-15  1.164e-14 -1.360e-01  0.89160    
## Away_TeamSEVILLA FC            2.325e-15  1.165e-14  2.000e-01  0.84179    
## Away_TeamVALENCIA              2.787e-15  1.157e-14  2.410e-01  0.80972    
## Away_TeamVALLADOLID            3.643e-15  1.515e-14  2.400e-01  0.81001    
## Away_TeamVILLARREAL            1.259e-16  1.156e-14  1.100e-02  0.99132    
## `Home_Team_Possession_%`      -5.458e-16  5.874e-16 -9.290e-01  0.35287    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots     5.194e-16  8.881e-15  5.800e-02  0.95337    
## Home_Team_On_Target_Shots      1.182e-15  8.882e-15  1.330e-01  0.89412    
## Home_Team_Total_Shots         -8.296e-16  8.844e-15 -9.400e-02  0.92528    
## Home_Team_Blocked_Shots       -6.959e-17  8.856e-15 -8.000e-03  0.99373    
## Home_Team_Corners              4.995e-17  7.303e-16  6.800e-02  0.94547    
## Home_Team_Throw_Ins            4.980e-16  3.192e-16  1.560e+00  0.11889    
## `Home_Team_Pass_Success_%`     5.894e-16  6.257e-16  9.420e-01  0.34632    
## Home_Team_Aerials_Won          3.245e-17  3.323e-16  9.800e-02  0.92223    
## Home_Team_Clearances           3.430e-16  2.831e-16  1.212e+00  0.22576    
## Home_Team_Fouls                1.636e-16  4.651e-16  3.520e-01  0.72509    
## Home_Team_Yellow_Cards         1.000e+00  1.194e-15  8.377e+14  < 2e-16 ***
## Home_Team_Second_Yellow_Cards  8.731e-17  6.811e-15  1.300e-02  0.98977    
## Home_Team_Red_Cards           -6.648e-14  7.388e-15 -8.999e+00  < 2e-16 ***
## Away_Team_Off_Target_Shots     7.694e-16  7.627e-15  1.010e-01  0.91966    
## Away_Team_On_Target_Shots     -7.360e-16  7.659e-15 -9.600e-02  0.92345    
## Away_Team_Total_Shots         -1.148e-16  7.601e-15 -1.500e-02  0.98795    
## Away_Team_Blocked_Shots        5.295e-16  7.662e-15  6.900e-02  0.94491    
## Away_Team_Corners              3.664e-16  7.991e-16  4.580e-01  0.64669    
## Away_Team_Throw_Ins            1.768e-16  3.413e-16  5.180e-01  0.60436    
## `Away_Team_Pass_Success_%`    -7.188e-16  5.828e-16 -1.233e+00  0.21761    
## Away_Team_Aerials_Won         -1.078e-17  3.283e-16 -3.300e-02  0.97382    
## Away_Team_Clearances           1.967e-16  2.606e-16  7.550e-01  0.45027    
## Away_Team_Fouls                4.396e-16  4.600e-16  9.560e-01  0.33936    
## Away_Team_Yellow_Cards         1.000e+00  1.214e-15  8.238e+14  < 2e-16 ***
## Away_Team_Second_Yellow_Cards  2.385e-15  5.877e-15  4.060e-01  0.68491    
## Away_Team_Red_Cards            6.626e-15  7.237e-15  9.160e-01  0.35995    
## Home_Team_Goals_Scored         1.783e-15  2.090e-15  8.530e-01  0.39370    
## Away_Team_Goals_Scored         1.707e-15  2.361e-15  7.230e-01  0.46978    
## year                          -4.864e-13  2.149e-13 -2.263e+00  0.02372 *  
## scorex                         8.315e-15  5.247e-15  1.585e+00  0.11312    
## score2                         1.172e-14  7.447e-15  1.574e+00  0.11573    
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -1.258e-14  5.656e-15 -2.224e+00  0.02628 *  
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## total_red_cards                       NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 7.497e-14 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 2.286e+28 on 92 and 2187 DF,  p-value: < 2.2e-16
lm_rojas <- lm(total_red_cards~., data = train)
summary(lm_rojas)
## 
## Call:
## lm(formula = total_red_cards ~ ., data = train)
## 
## Residuals:
##        Min         1Q     Median         3Q        Max 
## -3.830e-14 -1.270e-16 -1.900e-17  9.900e-17  7.668e-15 
## 
## Coefficients: (16 not defined because of singularities)
##                                 Estimate Std. Error    t value Pr(>|t|)    
## (Intercept)                    1.363e-11  5.190e-12  2.626e+00 0.008689 ** 
## ...1                           1.794e-17  6.781e-18  2.646e+00 0.008204 ** 
## Home_TeamALMERÍA               1.421e-17  2.377e-16  6.000e-02 0.952326    
## Home_TeamATHLETIC             -6.885e-18  1.374e-16 -5.000e-02 0.960039    
## Home_TeamATLETICO MADRID       1.300e-16  1.390e-16  9.350e-01 0.349748    
## Home_TeamBARCELONA             4.289e-16  1.616e-16  2.655e+00 0.007996 ** 
## Home_TeamCELTA                 2.524e-18  1.415e-16  1.800e-02 0.985771    
## Home_TeamCÓRDOBA               2.055e-16  2.379e-16  8.640e-01 0.387801    
## Home_TeamDEPORTIVO            -1.546e-16  1.509e-16 -1.024e+00 0.305895    
## Home_TeamEIBAR                -2.960e-16  1.401e-16 -2.113e+00 0.034698 *  
## Home_TeamELCHE                -9.340e-17  2.384e-16 -3.920e-01 0.695255    
## Home_TeamESPANYOL             -1.095e-16  1.360e-16 -8.050e-01 0.420694    
## Home_TeamGETAFE               -2.765e-17  1.432e-16 -1.930e-01 0.846907    
## Home_TeamGIJÓN                -6.294e-17  1.848e-16 -3.400e-01 0.733518    
## Home_TeamGIRONA               -1.129e-16  1.818e-16 -6.210e-01 0.534692    
## Home_TeamGRANADA              -1.694e-16  1.492e-16 -1.135e+00 0.256421    
## Home_TeamHUESCA               -2.120e-16  2.336e-16 -9.070e-01 0.364271    
## Home_TeamLAS PALMAS            2.898e-17  1.703e-16  1.700e-01 0.864861    
## Home_TeamLEGANÉS               4.467e-17  1.478e-16  3.020e-01 0.762576    
## Home_TeamLEVANTE               7.530e-18  1.419e-16  5.300e-02 0.957688    
## Home_TeamMÁLAGA               -6.149e-16  1.506e-16 -4.082e+00 4.62e-05 ***
## Home_TeamMALLORCA             -5.799e-16  2.345e-16 -2.473e+00 0.013474 *  
## Home_TeamOSASUNA              -3.582e-17  1.828e-16 -1.960e-01 0.844634    
## Home_TeamRAYO VALLECANO        3.713e-17  1.657e-16  2.240e-01 0.822667    
## Home_TeamREAL BETIS           -2.032e-17  1.467e-16 -1.390e-01 0.889835    
## Home_TeamREAL MADRID          -1.111e-17  1.536e-16 -7.200e-02 0.942319    
## Home_TeamREAL SOCIEDAD         3.759e-17  1.401e-16  2.680e-01 0.788459    
## Home_TeamSEVILLA FC            5.898e-17  1.422e-16  4.150e-01 0.678401    
## Home_TeamVALENCIA              6.072e-17  1.396e-16  4.350e-01 0.663584    
## Home_TeamVALLADOLID           -2.441e-16  1.829e-16 -1.335e+00 0.182136    
## Home_TeamVILLARREAL           -4.508e-18  1.397e-16 -3.200e-02 0.974264    
## Away_TeamALMERÍA               3.662e-16  2.375e-16  1.542e+00 0.123295    
## Away_TeamATHLETIC              3.890e-17  1.375e-16  2.830e-01 0.777303    
## Away_TeamATLETICO MADRID       3.891e-16  1.391e-16  2.797e+00 0.005208 ** 
## Away_TeamBARCELONA             2.739e-16  1.622e-16  1.688e+00 0.091534 .  
## Away_TeamCELTA                 2.870e-16  1.398e-16  2.054e+00 0.040139 *  
## Away_TeamCÓRDOBA               5.004e-16  2.377e-16  2.105e+00 0.035366 *  
## Away_TeamDEPORTIVO             1.623e-16  1.514e-16  1.072e+00 0.283886    
## Away_TeamEIBAR                 1.251e-16  1.388e-16  9.010e-01 0.367500    
## Away_TeamELCHE                 9.939e-16  2.376e-16  4.183e+00 2.99e-05 ***
## Away_TeamESPANYOL              2.108e-16  1.359e-16  1.551e+00 0.120984    
## Away_TeamGETAFE                2.790e-16  1.429e-16  1.952e+00 0.051026 .  
## Away_TeamGIJÓN                 5.070e-16  1.832e-16  2.767e+00 0.005698 ** 
## Away_TeamGIRONA                2.426e-16  1.815e-16  1.336e+00 0.181548    
## Away_TeamGRANADA               3.596e-16  1.492e-16  2.411e+00 0.015986 *  
## Away_TeamHUESCA                1.213e-16  2.324e-16  5.220e-01 0.601884    
## Away_TeamLAS PALMAS            3.123e-16  1.675e-16  1.864e+00 0.062431 .  
## Away_TeamLEGANÉS               3.064e-16  1.478e-16  2.073e+00 0.038298 *  
## Away_TeamLEVANTE               2.529e-16  1.410e-16  1.794e+00 0.072944 .  
## Away_TeamMÁLAGA                2.348e-16  1.508e-16  1.557e+00 0.119669    
## Away_TeamMALLORCA              3.322e-16  2.342e-16  1.418e+00 0.156207    
## Away_TeamOSASUNA               2.864e-16  1.812e-16  1.581e+00 0.114038    
## Away_TeamRAYO VALLECANO        3.710e-16  1.658e-16  2.237e+00 0.025387 *  
## Away_TeamREAL BETIS            3.955e-16  1.465e-16  2.700e+00 0.006993 ** 
## Away_TeamREAL MADRID           1.712e-16  1.513e-16  1.132e+00 0.257881    
## Away_TeamREAL SOCIEDAD         2.628e-16  1.396e-16  1.882e+00 0.059906 .  
## Away_TeamSEVILLA FC            3.274e-16  1.396e-16  2.344e+00 0.019142 *  
## Away_TeamVALENCIA              1.758e-16  1.388e-16  1.267e+00 0.205292    
## Away_TeamVALLADOLID            1.609e-16  1.817e-16  8.850e-01 0.376020    
## Away_TeamVILLARREAL            2.999e-16  1.387e-16  2.163e+00 0.030645 *  
## `Home_Team_Possession_%`      -3.858e-18  7.044e-18 -5.480e-01 0.583990    
## `Away_Team_Possession_%`              NA         NA         NA       NA    
## Home_Team_Off_Target_Shots    -3.205e-16  1.065e-16 -3.010e+00 0.002647 ** 
## Home_Team_On_Target_Shots     -3.548e-16  1.065e-16 -3.331e+00 0.000879 ***
## Home_Team_Total_Shots          3.507e-16  1.061e-16  3.307e+00 0.000959 ***
## Home_Team_Blocked_Shots       -3.625e-16  1.062e-16 -3.413e+00 0.000655 ***
## Home_Team_Corners              9.020e-18  8.757e-18  1.030e+00 0.303160    
## Home_Team_Throw_Ins           -7.873e-19  3.828e-18 -2.060e-01 0.837064    
## `Home_Team_Pass_Success_%`     1.018e-18  7.503e-18  1.360e-01 0.892067    
## Home_Team_Aerials_Won         -1.118e-17  3.985e-18 -2.805e+00 0.005073 ** 
## Home_Team_Clearances           2.001e-18  3.394e-18  5.890e-01 0.555687    
## Home_Team_Fouls                4.558e-18  5.578e-18  8.170e-01 0.413915    
## Home_Team_Yellow_Cards        -5.983e-18  1.431e-17 -4.180e-01 0.676030    
## Home_Team_Second_Yellow_Cards -2.996e-17  8.168e-17 -3.670e-01 0.713800    
## Home_Team_Red_Cards            1.000e+00  8.859e-17  1.129e+16  < 2e-16 ***
## Away_Team_Off_Target_Shots     1.254e-17  9.146e-17  1.370e-01 0.890968    
## Away_Team_On_Target_Shots     -5.487e-18  9.184e-17 -6.000e-02 0.952368    
## Away_Team_Total_Shots         -7.730e-18  9.115e-17 -8.500e-02 0.932429    
## Away_Team_Blocked_Shots        9.257e-18  9.188e-17  1.010e-01 0.919760    
## Away_Team_Corners              1.062e-17  9.583e-18  1.108e+00 0.268105    
## Away_Team_Throw_Ins           -1.340e-18  4.092e-18 -3.270e-01 0.743402    
## `Away_Team_Pass_Success_%`    -5.331e-18  6.989e-18 -7.630e-01 0.445699    
## Away_Team_Aerials_Won          5.097e-18  3.937e-18  1.295e+00 0.195608    
## Away_Team_Clearances          -4.626e-19  3.125e-18 -1.480e-01 0.882325    
## Away_Team_Fouls                5.493e-18  5.516e-18  9.960e-01 0.319424    
## Away_Team_Yellow_Cards         1.034e-17  1.456e-17  7.100e-01 0.477659    
## Away_Team_Second_Yellow_Cards  8.658e-18  7.048e-17  1.230e-01 0.902243    
## Away_Team_Red_Cards            1.000e+00  8.678e-17  1.152e+16  < 2e-16 ***
## Home_Team_Goals_Scored         3.031e-17  2.506e-17  1.210e+00 0.226595    
## Away_Team_Goals_Scored         1.040e-17  2.831e-17  3.670e-01 0.713442    
## year                          -6.769e-15  2.577e-15 -2.627e+00 0.008684 ** 
## scorex                         1.086e-16  6.291e-17  1.726e+00 0.084484 .  
## score2                         1.580e-16  8.930e-17  1.770e+00 0.076931 .  
## goals                                 NA         NA         NA       NA    
## home_points                           NA         NA         NA       NA    
## away_points                           NA         NA         NA       NA    
## jornada                       -1.768e-16  6.783e-17 -2.607e+00 0.009189 ** 
## total_off_target_shots                NA         NA         NA       NA    
## total_on_target_shots                 NA         NA         NA       NA    
## total_shots                           NA         NA         NA       NA    
## total_blocked_shots                   NA         NA         NA       NA    
## total_corners                         NA         NA         NA       NA    
## total_throw_ins                       NA         NA         NA       NA    
## total_pass_success                    NA         NA         NA       NA    
## total_aerials_won                     NA         NA         NA       NA    
## total_clearances                      NA         NA         NA       NA    
## total_fouls                           NA         NA         NA       NA    
## total_yellow_cards                    NA         NA         NA       NA    
## total_second_yellow_cards             NA         NA         NA       NA    
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 8.99e-16 on 2187 degrees of freedom
## Multiple R-squared:      1,  Adjusted R-squared:      1 
## F-statistic: 3.238e+30 on 92 and 2187 DF,  p-value: < 2.2e-16


5.1 REGRESION BACKWARD STEPWISE

5.2 REGRESION FORWARD STEPWISE



6 CONCLUSIONES

Hay muchas variables que no afectan al resultado de un partido.
Los equipos locales ganan más.

Hay dos equipos que sobresalen (Madrid y Barsa)
Hay un grupo de equipos “buenos” (nunca han descendido, meten más goles…)

De cara al futuro:
Cuanto se parecen dos partidos?
Clusterizar equipos en buenos, medios y malos.
Incluir las rachas de victorias, dorrotas y empates.
Calcular los puntos que suma cada equipo por partido en función de ser local o visitante, del “nivel” del rival, etc.
Predecir el número de goles que va a marcar cada equipo en un partido, en vez de victoria/derrota/empate.